Total days between two dates — calendar or business days, with or without the end date counted — plus weeks-and-days and years-months-days breakdowns.
Free toolNo signupFormula shown
Saved & recent
CHECK ENTRYSAVED
RESULT
—
FORMULA USEDDays Between Dates Calculator
What the count means
June 1 to June 3 is two days by the default convention — the fencepost rule counts the midnights crossed, excluding both endpoints as full days. Flip the toggle to include the end date and the same span becomes three, the counting style used for return windows, hotel nights, and “you have X days” deadlines.
Calendar days vs business days
Calendar days count everything. Business days drop Saturdays and Sundays — the weekday count contracts and loan processing times run on. Public holidays are not removed, because they vary by country, state, and even bank; subtract them yourself if your deadline cares.
In spreadsheets
Excel and Google Sheets store dates as day counts, so =B1−A1 between two date cells returns calendar days directly (format the cell as a number, or you will get a weird date). =NETWORKDAYS(A1, B1) is the built-in business-day count, inclusive of both endpoints.
Worked example
How long is summer break, June 1 to September 7, 2026?
Jun 1 → Jul 1 = 30, → Aug 1 = 31 more, → Sep 1 = 31 more, → Sep 7 = 6 more.
98 days excluding the end date — exactly 14 weeks.
Business-days row: 70 weekdays, since the span starts on a Monday.
How to use it
Pick the start and end dates.
Choose whether the end date counts as a day.
Switch to business days if only weekdays matter.
Read the total, then the weeks and calendar breakdowns beneath.
Frequently asked questions
How do I calculate the days between two dates?
Subtract the earlier date from the later one at midnight-to-midnight precision; the difference in milliseconds divided by 86,400,000 is the day count. This page does exactly that in UTC so timezones and daylight saving cannot shift the answer.
Does the count include the end date?
Not by default — June 1 to June 3 counts as two days. Flip the toggle to include the end date and it becomes three, the inclusive counting that deadlines and return windows usually mean.
How do I count business days only?
Switch the basis to business days and Saturdays and Sundays drop out. Public holidays are not excluded, because they differ by country and state — subtract any that fall inside the span yourself.
How do I do this in Excel or Google Sheets?
Both store dates as day serial numbers, so =B1−A1 returns calendar days once the cell is formatted as a number. =NETWORKDAYS(A1, B1) counts weekdays, inclusive of both endpoints.
What if the end date is before the start date?
The tool takes the absolute span and tells you the dates were reversed. If you need a signed difference — for an overdue flag, say — compare the two dates yourself afterward.
How are the weeks and months breakdowns computed?
Weeks are plain division with the remainder shown as days. The years-months-days breakdown borrows real calendar month lengths, the same algorithm an age calculator uses, so month ends behave correctly.