How to use Days Between Dates
Elapsed time excludes the starting day. An inclusive range counts both the start and end dates, which is often useful for counting days in a booking or event. A range starting and ending on the same date is zero elapsed days or one inclusive day.
The calculation uses dates at UTC midnight, avoiding daylight-saving changes in the length of a local day. It counts all calendar days and does not remove weekends or public holidays.
The formula
A worked example
Start date: 2026-10-07 · End date: 2026-11-07 · Counting method: Elapsed days
Days between dates: 31 days
Elapsed days: the start date is excluded and the end date is included.
Questions about this calculation
Are weekends included?
Yes. Every calendar day in the range is counted.
Why do the counting methods differ by one?
The inclusive method also counts the start date.
Formula checks: 2026-10-08. Assumptions & corrections.