How to Calculate the Number of Days Between Two Dates

How to Calculate the Number of Days Between Two Dates: Days, weeks and weekdays
Spread the love

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-A1 or =DAYS(B1, A1).

Counting by hand

  1. First, count the days left in the starting month (including or excluding the start date, consistently).
  2. Then add the full months in between, using the table below.
  3. 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.

Related guides

Related guides

Leave a Reply

Your email address will not be published. Required fields are marked *