Count dates or find a new calendar date
- Choose Days between dates to compare two dates, or Add or subtract days to find a date from a day count.
- To find a date, choose a start date, enter a whole number of days or weeks, and choose before or after the start date.
- For an interval, choose whether to count both dates. Reversed dates are highlighted and can be swapped.
- Read the date illustration and copy the result with its counting rule.
Formats, output and limits
Gregorian dates from 0001-01-01 to 9999-12-31. Whole day/week offsets up to 3,652,058 days; the result must remain in range. No weekend, holiday or working-day exclusions. No automatic saving.
A worked example
28 February to 1 March 2024 is 2 elapsed calendar days, or 3 calendar dates when both endpoints are counted. Adding one day to 28 February 2024 gives 29 February.
Common questions
Does Count both dates add another day of elapsed time?
No. It changes the count of included calendar dates. Identical dates give zero elapsed days or one included date.
Are daylight-saving changes included?
This counts calendar dates, not elapsed hours. A calendar day boundary counts once even when local clocks change. Use a zone-aware timestamp conversion to inspect actual instants.
How is this different from Time Duration?
Days works with dates and date shifts. Time Duration accepts dates and clock times and reports months, days, hours, minutes and seconds under its stated wall-clock rules.