Days between dates
Count the days, weeks, months and weekdays between any two dates.
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
- Date calculator Add or subtract days, months, years
- Working days calculator Business days minus holidays
- Hours calculator Hours between two times
- Time card calculator Weekly hours, overtime and pay
- Military time converter Military time to standard and back
- Week number What week of the year it is
- Day of the year Day number, days left, Julian date
- Unix timestamp converter Epoch to date and back
- Hours from now Clock time after X minutes or hours
- Days from now The date X days from today
- Days ago The date X days before today
- Time zone converter Convert a time between places
- Long-weekend planner Best days to take leave