# Days Between Dates Calculator

> There are 90 days from November 10, 2026 to February 8, 2027, or 12 weeks and 6 days, and 64 of them are Monday-to-Friday business days; the end date is not counted unless you choose to include it. The same gap is also shown in months, years, hours and minutes.

- Interactive calculator: https://calculatorswithsteps.com/days-between-dates-calculator
- Category: Date & Time Calculators
- Last updated: 2026-11-10
- Publisher: Calculators With Steps (calculatorswithsteps.com)

## How to use the days between dates calculator

1. Enter the **start date**. It defaults to today.
2. Enter the **end date**. If you type an earlier date by mistake, the calculator swaps them for you and tells you it did.
3. Tick **Include the end date** if both the first and the last day should count, as in a hotel stay counted in days or a leave request that runs from Monday to Friday inclusive.

The answer shows the total number of days, the same span in weeks and days, months and days, and years, months and days, how many of the days fall on weekdays (Monday to Friday) and weekends, and the total hours and minutes.

## Formula for the days between two dates

Every calendar date can be turned into a day number: the count of days since a fixed starting point. This calculator counts from January 1, 1970. The number of days between two dates is then a subtraction:

**Days = day number of end date − day number of start date (+ 1 if you include the end date)**

Working with whole calendar days means time zones and daylight-saving changes have no effect. A span across a clock change, such as March 1 to March 15, 2026, is still exactly 14 days.

Weeks are the total divided by 7, with the remainder shown as days. Months and years are counted as completed calendar months: a month is complete when the same day of the month comes round again.

## Worked example

From Tuesday, November 10, 2026 to Monday, February 8, 2027, without the end date:

| Measure | Result |
| --- | --- |
| Total days | 90 days |
| Weeks and days | 12 weeks, 6 days |
| Months and days | 2 months, 29 days |
| Business days (Mon–Fri) | 64 |
| Weekend days | 26 |
| Total hours | 2,160 |

The day numbers are 20,767 and 20,857, and 20,857 − 20,767 = 90. For business days, 12 full weeks hold 60 weekdays, and the 6 leftover days (Tuesday to Sunday) add 4 more, for 64 in total.

## Should you include the end date?

Whether to count the last day depends on what you are measuring:

| Situation | Usual convention | Example |
| --- | --- | --- |
| Age, countdown, "how long ago" | Exclude the end date | Nov 10 to Dec 25, 2026 = 45 days |
| Leave, events, rentals billed per day | Include both dates | Mon Nov 9 to Fri Nov 13, 2026 = 5 days |
| Whole calendar year | Include both dates | Jan 1 to Dec 31, 2026 = 365 days |

If a contract or policy defines the period, follow its wording. "Within 30 days of" and "30 days inclusive" can differ by a day.

## Business days and weekend days

The business-day count includes every Monday to Friday inside the range, using the same start and end rule as the total. Business days plus weekend days always equal the total. Public holidays are not removed, because they differ by country, state and employer. Subtract one for each holiday that falls on a weekday in your range.

## Days between dates in Excel and Google Sheets

With the start date in A1 and the end date in B1:

- `=B1-A1` returns the number of days, not counting the end date.
- `=DATEDIF(A1,B1,"d")` returns the same number. Use `"m"` for completed months or `"y"` for completed years.
- `=NETWORKDAYS(A1,B1)` counts weekdays and includes both dates. Microsoft's own example gives 110 working days from October 1, 2012 to March 1, 2013.
- `=NETWORKDAYS(A1,B1,C1:C5)` also skips the holiday dates listed in C1:C5.

## Common uses

- **Deadlines and notice periods.** To find the date that is a set number of days away rather than count the gap, use the [date calculator](https://calculatorswithsteps.com/date-calculator).
- **Interest for part of a year.** Simple interest for a short loan or deposit uses the exact number of days; the [simple interest calculator](https://calculatorswithsteps.com/simple-interest-calculator) does the rest.
- **Ages and anniversaries.** The [age calculator](https://calculatorswithsteps.com/age-calculator) gives an exact age in years, months and days and shows your next birthday.
- **Long spans.** From January 1, 2000 to November 10, 2026 is 9,810 days, or 26 years, 10 months and 9 days.

## Frequently asked questions

### How do I calculate the number of days between two dates?

Subtract the earlier date from the later one. Convert each date to a day count, take the difference, and you have the number of days. From November 10, 2026 to December 25, 2026 is 45 days.

### Does the count include the start date and the end date?

By default the start date is counted and the end date is not, which is what subtracting two dates gives you. Monday to Friday of the same week is 4 days that way. Tick Include the end date to count both days, which gives 5.

### How many business days are between two dates?

Count only Monday to Friday. From November 10, 2026 to February 8, 2027 there are 90 days in total, of which 64 are business days and 26 are weekend days. Public holidays are not removed automatically.

### How do I calculate days between dates in Excel?

With the start date in A1 and the end date in B1, =B1-A1 gives the number of days and =DATEDIF(A1,B1,"d") gives the same answer. =NETWORKDAYS(A1,B1) counts working days and includes both the start and end dates.

### How many days are there between January 1 and December 31?

In 2026 it is 364 days if you don't count December 31, or 365 days if you include it. In a leap year such as 2028 each figure is one day higher.

### What happens if the end date is before the start date?

The calculator swaps the dates and shows the gap as a positive number with a note. December 25, 2026 back to November 10, 2026 is still 45 days.

### How many days are there until Christmas?

From November 10, 2026, Christmas Day is 45 days away, which is 6 weeks and 3 days, or 1 month and 15 days. Set the start date to today to get a live countdown.

### How are months counted when the start date is the 31st?

A month counts once the same day number is reached in a later month. January 31, 2027 to February 28, 2027 is 28 days and 0 months, because February has no 31st. January 31 to March 1, 2027 counts as 1 month.

## Sources

- [Microsoft Support – NETWORKDAYS function](https://support.microsoft.com/en-us/office/networkdays-function-48e717bf-a7a3-495f-969e-5005e3eb18e7)
- [Microsoft Support – DATEDIF function](https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c)
- [Wikipedia – Gregorian calendar](https://en.wikipedia.org/wiki/Gregorian_calendar)