Days Between Dates Calculator
How many days are there between two dates? This day counter takes a start and an end date and gives the total days, weeks, months and business days. For example, there are 35 days from today to Christmas.
Days from today to upcoming US dates
| Date | When | Days away | Weeks |
|---|---|---|---|
| Thanksgiving | Thu, Nov 26, 2026 | 6 | 6 days |
| First day of winter (shortest day) | Mon, Dec 21, 2026 | 31 | 4 weeks and 3 days |
| Christmas | Fri, Dec 25, 2026 | 35 | 5 weeks |
| New Year’s Day | Fri, Jan 1, 2027 | 42 | 6 weeks |
| First day of spring | Sat, Mar 20, 2027 | 120 | 17 weeks and 1 day |
| Easter | Sun, Mar 28, 2027 | 128 | 18 weeks and 2 days |
| Tax Day (federal filing deadline) | Thu, Apr 15, 2027 | 146 | 20 weeks and 6 days |
| Memorial Day | Mon, May 31, 2027 | 192 | 27 weeks and 3 days |
| First day of summer | Mon, Jun 21, 2027 | 213 | 30 weeks and 3 days |
| Independence Day | Sun, Jul 4, 2027 | 226 | 32 weeks and 2 days |
| Halloween | Sun, Oct 31, 2027 | 345 | 49 weeks and 2 days |
How to count the days between two dates by hand
Count the days left in the starting month, add the full months in between, then add the day of the month you are counting to. From today to Christmas:
10 days left in November + 25 (December) = 35 days
This counts the end date but not the start date, the standard way to measure “days between”. If both dates should count, as with a hotel stay or days of leave, add one.
Calendar days, inclusive days and business days
The same two dates can give different answers depending on what you count. From Monday, March 2, 2026 to Friday, March 13, 2026:
| Counting method | Result | Used for |
|---|---|---|
| Calendar days (end date only) | 11 days | Most deadlines, “days between”, interest periods |
| Inclusive (both dates) | 12 days | Hotel stays, leave, rentals, event durations |
| Business days (after the start date) | 9 days | Shipping, payments, legal and HR deadlines |
| Excel NETWORKDAYS (both dates) | 10 days | Spreadsheets. It counts the start date too |
Days between dates in Excel and Google Sheets
- Total days:
=B2-A2or=DAYS(B2,A2). Format the cell as a number, not a date. - Whole months or years:
=DATEDIF(A2,B2,"m")or=DATEDIF(A2,B2,"y"). - Working days:
=NETWORKDAYS(A2,B2,H2:H12), where H2:H12 lists the holidays to skip. It includes both the start and end date, so its answer is often one higher than this calculator’s.
Common date spans in 2027
How long the familiar stretches of the year last, end date not counted. Holidays set by weekday move each year, so these spans change too.
| From | To | Days | Weeks |
|---|---|---|---|
| New Year’s Day, Fri, Jan 1, 2027 | Tax Day, Thu, Apr 15, 2027 | 104 | 14 weeks and 6 days |
| New Year’s Day, Fri, Jan 1, 2027 | Independence Day, Sun, Jul 4, 2027 | 184 | 26 weeks and 2 days |
| Memorial Day, Mon, May 31, 2027 | Labor Day, Mon, Sep 6, 2027 | 98 | 14 weeks |
| Labor Day, Mon, Sep 6, 2027 | Thanksgiving, Thu, Nov 25, 2027 | 80 | 11 weeks and 3 days |
| Thanksgiving, Thu, Nov 25, 2027 | Christmas, Sat, Dec 25, 2027 | 30 | 4 weeks and 2 days |
| January 1, Fri, Jan 1, 2027 | December 31, Fri, Dec 31, 2027 | 364 | 52 weeks |
Days in each month of 2026
| Month | Days | Month | Days |
|---|---|---|---|
| January | 31 | July | 31 |
| February | 28 | August | 31 |
| March | 31 | September | 30 |
| April | 30 | October | 31 |
| May | 31 | November | 30 |
| June | 30 | December | 31 |
2026 has 365 days. Leap years, when February has 29 days, are divisible by 4, except century years not divisible by 400. The next leap year is 2028.
Frequently asked questions
How many days are between two dates?
Pick a start date and an end date. The calculator shows the total number of days plus the same period in years, months and days, in weeks, and in business days.
Should I include the end date?
By default the end date is not counted, so Monday to Tuesday is 1 day. Tick “Include the end date” if you are counting days you are present or working, such as a hotel stay or a leave period, where both the first and last day count.
How are business days counted?
Business days are Monday to Friday. By default the count also skips US federal holidays, using their observed dates. You can switch to weekends only, or to Indian national holidays.
Why can the month count differ from other tools?
Months have different lengths. This calculator counts whole calendar months first, then the remaining days. For example, Jan 31 to Mar 1 is 1 month and 1 day in a non-leap year.
How do I count the days between two dates in Excel or Google Sheets?
Subtract the dates: =B2-A2, or use =DATEDIF(A2,B2,"d"). For working days use =NETWORKDAYS(A2,B2), which counts both the start and end date.