How to Count the Days Between Two Dates
Whether you're counting down to a deadline, working out a notice period or checking how old a document is, counting days is easy once you know two things: how long each month is, and whether to include the end date.
Month lengths and leap years
Months have 28 to 31 days. The old rhyme still works: “Thirty days hath September, April, June and November; all the rest have thirty-one, except February…”. You can also count on your knuckles: knuckles are 31-day months, gaps are 30 (or February).
| 31 days | 30 days | 28 or 29 days |
|---|---|---|
| Jan, Mar, May, Jul, Aug, Oct, Dec | Apr, Jun, Sep, Nov | Feb |
Leap years add a 29 February. A year is a leap year if it divides by 4, except century years, which must divide by 400. So 2024 and 2028 are leap years, 2000 was, but 1900 and 2100 are not. A normal year has 365 days; a leap year has 366.
Counting days by hand
Count the days left in the starting month, add every full month in between, then add the days into the final month.
Example: 15 March 2026 to 4 July 2026
- Rest of March: 31 − 15 = 16 days.
- Full months: April 30 + May 31 + June 30 = 91 days.
- Into July: 4 days.
- Total: 16 + 91 + 4 = 111 days.
For long spans, count whole years first (365 days each, plus 1 for every 29 February you pass), then finish with the months and days.
Include the end date or not?
This is the most common source of “off by one” answers. The method above counts the gap between dates, the same way you'd say Monday to Tuesday is 1 day. That is the standard answer.
If you need to count both the first and last day, for example the number of days a hotel booking, a trip or a course runs on the calendar, add 1. So 1 January to 31 December 2026 is 364 days apart, but covers 365 calendar days when you include both ends.
Contracts and legal deadlines may have their own counting rules (for instance, excluding the day of an event), so check the wording.
Converting to weeks, months and years
- Weeks: divide by 7. 111 days = 15 weeks and 6 days.
- Months: months vary in length, so “months between” is best counted on the calendar: 15 March to 15 June is exactly 3 months. Dividing days by 30.44 (the average month) gives an estimate only.
- Years: divide by 365.25 for an average that allows for leap years.
If you only need working days, weekends and holidays have to be removed. Use our business days calculator for that.
Adding or subtracting days from a date
To find the date 90 days after 9 November 2026: 21 days finish November, 31 take you through December, 31 through January. That's 83 days, and 7 more lands on 7 February 2027. Our date calculator does this instantly, including the weekday.
In Excel or Google Sheets
- Days between: put the dates in A1 and B1, then use
=B1-A1(format the result as a number). - Including the end date:
=B1-A1+1 - Working days:
=NETWORKDAYS(A1,B1). This one counts both end dates. - Whole months or years:
=DATEDIF(A1,B1,"m")or"y"
Common mistakes
- Counting both ends when you only wanted the gap (or vice versa).
- Assuming every month has 30 days.
- Forgetting 29 February in leap years.
- Mixing date formats. 03/04 is 3 April in the UK but March 4 in the US.
Frequently asked questions
How many days are there between two dates?
Subtract the earlier date from the later one: days left in the first month, plus full months, plus days into the last month. Add 1 if you want to include both dates.
Should I include the end date?
For a plain gap between dates, no. For counting calendar days something runs (a trip or booking), add 1 to include both ends.
How many days are in a year?
365, or 366 in a leap year such as 2024 or 2028.
How do I count days between dates in Excel?
Use =B1-A1 with the later date in B1. Add +1 to include both dates, or use NETWORKDAYS for working days.
What date is 90 days from today?
It depends on the start date. From 9 November 2026 it is 7 February 2027. Use the date calculator for any start date.
References
- Microsoft Support: DATEDIF and NETWORKDAYS function reference.