Skip to content

Days between dates

Count the days, weeks, months and weekdays between any two dates.

100 days

Weeks
14 weeks, 2 days
Years, months, days
0 y, 3 m, 8 d
Weekdays (Mon–Fri)
71
Weekend days
29
Hours
2,400

Need business days excluding public holidays? Use the working days calculator.

Frequently asked questions

How do I count the days between two dates?

Enter a start date and an end date. The calculator subtracts the start from the end, so 1 January to 2 January is 1 day. Tick “Include the end date” to count both days, which gives 2.

How many days is 100 days from today?

From Sunday, November 15, 2026, 100 days later is Tuesday, February 23, 2027. That is 14 weeks and 2 days.

How do I calculate days between dates in Excel or Google Sheets?

Use =DAYS(end_date, start_date) or simply =end_date - start_date. For weekdays only, use =NETWORKDAYS(start_date, end_date), which counts both ends and can take a list of holidays as a third argument.

Are leap years and daylight saving time handled?

Yes. Dates are counted as calendar days, so 29 February is included in leap years, and daylight saving changes never add or remove a day.

More date and time tools