How to Calculate the Number of Days Between Two Dates
Counting days until a deadline, a trip or a due date is easy to get wrong by one. Here’s how a date calculator works out the number of days between two dates, and how to do it yourself.
Quick answer
- Subtract the earlier date from the later one. From 1 January 2026 to 25 December 2026 is 358 days.
- Add 1 if you want to count both the start and end dates (359 days).
- In Excel or Google Sheets:
=B1-A1or=DAYS(B1, A1).
Counting by hand
- First, count the days left in the starting month (including or excluding the start date, consistently).
- Then add the full months in between, using the table below.
- Finally, add the days in the final month.
| Month | Days |
|---|---|
| January | 31 |
| February | 28 (29 in a leap year) |
| March | 31 |
| April | 30 |
| May | 31 |
| June | 30 |
| July | 31 |
| August | 31 |
| September | 30 |
| October | 31 |
| November | 30 |
| December | 31 |
For example, 10 March to 2 May 2026: 21 days left in March + 30 in April + 2 in May = 53 days.
Should you include the end date?
Subtracting dates gives the number of nights between them, which is how hotels, loans and “days until” counts work. However, if you’re counting days of an event that runs from Monday to Friday inclusive, add one: Monday to Friday is 4 days apart, but the event lasts 5 days.
Weekdays only
To count working days, leave out Saturdays and Sundays. From 1 to 31 December 2026 there are 23 weekdays, before any holidays. In Excel and Google Sheets, =NETWORKDAYS(A1, B1) counts weekdays including both dates, and an optional third argument lists holidays to skip.
Converting days to weeks or months
- Weeks: divide by 7. 358 days = 51 weeks and 1 days.
- Months: there’s no exact conversion because months vary; on average a month is about 30.44 days.
- Years: see how many days in a year, including leap years.
For ages in years, months and days, see how to calculate age.
Frequently asked questions
How do I calculate days between two dates?
Subtract the earlier date from the later one, or use =B1-A1 in a spreadsheet.
How many days from 1 January to 25 December 2026?
358 days (359 if you count both dates).
How do I count only weekdays?
Use NETWORKDAYS in Excel or Google Sheets, or skip Saturdays and Sundays when counting.
Do leap years matter?
Yes. If the range includes 29 February of a leap year, there’s one extra day.
