Days between dates
Enter two dates to count the days between them, in total, in weeks, in months and years, and in business days. Leave the start date as today for a countdown.
Days between dates calculator
44 days
From today, Wednesday, November 11, 2026, to Friday, December 25, 2026.
- Weeks and days
- 6 weeks and 2 days
- Months and days
- 1 month and 14 days
- Business days (Mon–Fri)
- 32
- Weekend days
- 12
- Hours (24 per day)
- 1,056
- Counting both dates
- 45 days
How many days until…
Days from today, Wednesday, November 11, 2026, to the next occurrence of each date. A count of 0 means the day is today.
| Day | Next date | Days |
|---|---|---|
| New Year’s Day | Friday, January 1, 2027 | 51 |
| Valentine’s Day | Sunday, February 14, 2027 | 95 |
| St. Patrick’s Day | Wednesday, March 17, 2027 | 126 |
| Independence Day | Sunday, July 4, 2027 | 235 |
| Halloween | Sunday, October 31, 2027 | 354 |
| Christmas Day | Friday, December 25, 2026 | 44 |
| New Year’s Eve | Thursday, December 31, 2026 | 50 |
| Thanksgiving Day | Thursday, November 26, 2026 | 15 |
| Memorial Day | Monday, May 31, 2027 | 201 |
| Labor Day | Monday, September 6, 2027 | 299 |
Thanksgiving, Memorial Day and Labor Day move each year: the fourth Thursday of November, the last Monday of May and the first Monday of September (5 U.S.C. 6103). For any other date, set the end date above.
How the days between two dates are counted
The calculator subtracts the start date from the end date. From November 1 to November 30 is 29 days: the 30 days of the month, minus the start day itself. This is the count you want for “how long until” and “how long ago”, and it is what a spreadsheet gives for =B1-A1 or =DAYS(B1,A1) (Microsoft).
Counting both days
When both the first and the last day count, as for a hotel stay counted in days rather than nights, a holiday “from the 1st to the 30th inclusive”, or the number of days someone worked, add one. A booking from Friday to Sunday is 2 nights but 3 days.
Months and years
Months are counted forward from the start date to the same day number, then the leftover days are added. From January 15 to March 20 is 2 months and 5 days. From January 31, one month later is the last day of February, because February has no 31st. The same method gives ages: someone born on February 29 turns one year older on February 28 in common years by this count; laws and institutions may use March 1 instead.
Business days and holidays
Business days are the Mondays to Fridays after the start date up to and including the end date. With the holiday box ticked, the days off that most US federal employees receive for the eleven legal public holidays are removed too, including the Friday or Monday off when a holiday falls on a weekend (OPM). Excel’s NETWORKDAYS includes the start date as well when it is a weekday; Microsoft’s own example, October 1, 2012 to March 1, 2013, gives 110 working days (Microsoft), one more than this calculator, which leaves out the starting Monday.
Spreadsheet formulas
| To find | Formula (start in A1, end in B1) |
|---|---|
| Days between | =B1-A1 or =DAYS(B1,A1) |
| Days, counting both dates | =B1-A1+1 |
| Working days (both ends counted) | =NETWORKDAYS(A1,B1) |
| Whole months | =DATEDIF(A1,B1,"M") |
| Whole years | =DATEDIF(A1,B1,"Y") |
| Days until a date from today | =B1-TODAY() |
Microsoft keeps DATEDIF for compatibility with Lotus 1-2-3 and warns that its “MD” unit has known problems (Microsoft).
Questions about counting days between dates
Does “days between” include the start and end dates?
The usual count, and the one Excel’s DAYS function gives, is the difference: from Monday to Wednesday is 2 days. That counts the end date but not the start date. If both days count, as in “Monday through Wednesday”, add one: 3 days. Tick “include the end date” to get that number.
How do I count business days between two dates?
Count the Mondays to Fridays after the start date up to and including the end date, then subtract any holidays that fall on those weekdays. Excel’s NETWORKDAYS counts both the start and the end date when they are weekdays, so its answer is one higher when the start date is a weekday.
How many days are in a year?
A common year has 365 days and a leap year 366. Over the 400-year Gregorian cycle the average is 365.2425 days, because 97 of every 400 years are leap years.
Why does the month count look off by a day for some dates?
Months have different lengths, so “1 month” from January 31 ends on February 28 (or 29). The calculator counts whole months forward from the start date, moving to the end of the month when the day does not exist, and then counts the remaining days.
Do time zones or daylight saving time change the number of days?
Not for calendar dates. Counting from one date to another counts days, whatever the clocks do. Only a count in hours is affected: a day with a spring-forward clock change has 23 hours, and a fall-back day has 25.
To move a date forward or back by a number of days instead, use days from today; to see the dates laid out, open the calendar.
More date and time tools
- Today’s date The date and day where you are, in every format
- What time is it Exact time, UTC offset and daylight saving time
- Days from today Count days, weeks or months forward or back
- Day of the week The weekday of any date, and how to work it out
- Week number ISO 8601 and US week numbers for any year
- Calendar Printable year calendar with week numbers
- Julian date Day of the year, YYDDD codes and Julian Day
- Time zone converter Convert a time between any two zones
- Leap year The leap year rule, next leap year, leap seconds
- Date formats How to write the date, by country and use