How to Calculate the Number of Days Between Two Dates
To count the days between two dates, subtract the earlier date from the later one. From 1 March to 31 March 2026 is 30 days. If you want to count both the first and the last day, as you would for a hotel stay or a leave request, add 1 to get 31 days.
Elapsed days vs inclusive days
This one decision causes most counting mistakes.
- Elapsed days measure the time between the dates: 1 March to 31 March is 30 days. Use this for ages, deadlines and "how long until".
- Inclusive days count every calendar date in the range: 1 March to 31 March is 31 days. Use this for bookings, holidays and leave.
The date difference calculator gives elapsed days, and the days between inclusive calculator counts both ends.
Counting by hand
- Count the days left in the start month after the start date.
- Add the full months in between, using their real lengths.
- Add the day number of the end date.
Example: 15 January to 10 March 2026. January has 16 days left after the 15th, February 2026 has 28 days and March adds 10: 16 + 28 + 10 = 54 days.
Remember which months have 31 days (January, March, May, July, August, October, December) and that February has 29 days in a leap year.
Converting to weeks
Divide the days by 7. From 1 January to 25 December 2026 is 358 days, which is 51 full weeks and 1 day. The weeks between dates calculator shows full weeks and the remaining days.
Weekdays and weekend days
For work schedules you often need only Monday to Friday. In March 2026 there are 22 weekdays after 1 March, and 9 weekend days across the whole month. The business days calculator counts weekdays and the weekend days between dates tool counts Saturdays and Sundays. Public holidays differ by country, so subtract them yourself.
Spreadsheet formulas
- Excel and Google Sheets: =B1-A1 gives elapsed days when both cells contain dates.
- =B1-A1+1 gives inclusive days.
- =NETWORKDAYS(A1,B1) counts weekdays, including both ends.
Questions and answers
How many days are there between 1 March and 31 March?
30 elapsed days, or 31 if you count both the first and the last day.
Do date calculators include the end date?
It depends on the tool. Elapsed day counts do not include the start date; inclusive counts include both. Check which one you need.