Home / Guides / How to Count the Days Between Two Dates

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.

By Dr. Muhammad Amjad Khadim, PhD (Mathematics) · Published · How we check our content

Want the answer straight away?Open the Days Between Dates Calculator →

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 days30 days28 or 29 days
Jan, Mar, May, Jul, Aug, Oct, DecApr, Jun, Sep, NovFeb

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

  1. Rest of March: 31 − 15 = 16 days.
  2. Full months: April 30 + May 31 + June 30 = 91 days.
  3. Into July: 4 days.
  4. 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

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

Common mistakes

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

  1. Microsoft Support: DATEDIF and NETWORKDAYS function reference.
About the author

Dr. Muhammad Amjad Khadim holds a PhD in Mathematics and writes and checks the formulas behind Adzita's calculators and guides. Google Scholar profile.

More guides

Roman Numerals: Chart, Rules and How to ConvertLearn to read and write Roman numerals with a 1–100 chart, years like 2026 (MMXXVI), the six subtractive…How to Find the Slope of a LineLearn the slope formula m = (y₂ − y₁)/(x₂ − x₁) with worked examples, the four types of slope, y = mx + b,…How to Add and Subtract Time in Hours and MinutesAdd and subtract hours and minutes the easy way, convert minutes to decimal hours for timesheets, and handle…How Much Paint Do I Need for a Room?Work out how much paint you need in gallons or liters: measure walls, subtract doors and windows, allow for…