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.

Result
Calculating…

Days from today to upcoming US dates

DateWhenDays awayWeeks
ThanksgivingThu, Nov 26, 202666 days
First day of winter (shortest day)Mon, Dec 21, 2026314 weeks and 3 days
ChristmasFri, Dec 25, 2026355 weeks
New Year’s DayFri, Jan 1, 2027426 weeks
First day of springSat, Mar 20, 202712017 weeks and 1 day
EasterSun, Mar 28, 202712818 weeks and 2 days
Tax Day (federal filing deadline)Thu, Apr 15, 202714620 weeks and 6 days
Memorial DayMon, May 31, 202719227 weeks and 3 days
First day of summerMon, Jun 21, 202721330 weeks and 3 days
Independence DaySun, Jul 4, 202722632 weeks and 2 days
HalloweenSun, Oct 31, 202734549 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 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.

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.

FromToDaysWeeks
New Year’s Day, Fri, Jan 1, 2027Tax Day, Thu, Apr 15, 202710414 weeks and 6 days
New Year’s Day, Fri, Jan 1, 2027Independence Day, Sun, Jul 4, 202718426 weeks and 2 days
Memorial Day, Mon, May 31, 2027Labor Day, Mon, Sep 6, 20279814 weeks
Labor Day, Mon, Sep 6, 2027Thanksgiving, Thu, Nov 25, 20278011 weeks and 3 days
Thanksgiving, Thu, Nov 25, 2027Christmas, Sat, Dec 25, 2027304 weeks and 2 days
January 1, Fri, Jan 1, 2027December 31, Fri, Dec 31, 202736452 weeks

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.

Related calculators