Days Between Dates Calculator

How many days are there between two dates? Pick a start and an end date to get the total days, weeks, months and business days. For example, there are 80 days from today to Christmas.

Result
Calculating…

Days from today to upcoming US dates

DateWhenDays awayWeeks
HalloweenSat, Oct 31, 2026253 weeks and 4 days
ThanksgivingThu, Nov 26, 2026517 weeks and 2 days
First day of winter (shortest day)Mon, Dec 21, 20267610 weeks and 6 days
ChristmasFri, Dec 25, 20268011 weeks and 3 days
New Year’s DayFri, Jan 1, 20278712 weeks and 3 days
First day of springSat, Mar 20, 202716523 weeks and 4 days
EasterSun, Mar 28, 202717324 weeks and 5 days
Tax Day (federal filing deadline)Thu, Apr 15, 202719127 weeks and 2 days
Memorial DayMon, May 31, 202723733 weeks and 6 days
First day of summerMon, Jun 21, 202725836 weeks and 6 days
Independence DaySun, Jul 4, 202727138 weeks and 5 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:

25 days left in October + 30 (November) + 25 (December) = 80 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 methodResultUsed for
Calendar days (end date only)11 daysMost deadlines, “days between”, interest periods
Inclusive (both dates)12 daysHotel stays, leave, rentals, event durations
Business days (after the start date)9 daysShipping, payments, legal and HR deadlines
Excel NETWORKDAYS (both dates)10 daysSpreadsheets. It counts the start date too

Days between dates in Excel and Google Sheets

  • Total days: =B2-A2 or =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.

Days in each month of 2026

MonthDaysMonthDays
January31July31
February28August31
March31September30
April30October31
May31November30
June30December31

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.

More date calculators