The gap between two dates, counted properly
Pick a first date and a second date. The result gives total days, then the same gap as weeks and days, then as years, months and days. A single sentence at the top states the answer in words, so you can copy it straight into a message or a note.
By default the end date is not counted, which is how most people count a gap: Monday to Wednesday is two days. Tick "include end date" when you want both days counted, for example for a booking that covers the first and the last night, or a streak where today counts.
The wording follows your dates. If the first date is in the past, the sentence says "since", and if it is ahead, it says "until". That means the same page answers "how many days since" a date, "how many days until" one, and how many years of service lie between a start date and today.
The count is by calendar date, not by 24-hour blocks, so a clock change does not shift the answer. For a live ticking countdown to a future moment, use the days until tool instead.
Worked examples
Questions about this tool
Does the count include the start day or the end day?
Neither by default. Tick the include-end-date box to count the final day as well, which adds one.
What if my first date is later than the second?
The tool still gives the gap and adjusts the "since" or "until" wording to match the order.
Does it skip weekends?
No, it counts every calendar day. Use the business days calculator to leave out weekends.
Does a daylight saving change affect the result?
No. Dates are compared as calendar days, so a 23-hour or 25-hour day still counts as one.
What is the Excel or Google Sheets formula for days between two dates?
With the dates in A1 and B1, =B1-A1 gives the days between them and =DAYS(B1,A1) does the same. Add 1 to count both the first and the last day, which matches ticking the include-end-date box on this page.