Skip to content
PercentPoint

Date Calculator

Count the days between two dates, with the same span in weeks, months and business days, or add and subtract days, weeks, months and years from a date to see where you land and on which weekday.

For planning only. Your school, syllabus or accountant has the final word. First published · Last reviewed by PercentPoint.

How to use the date calculator

  1. Choose a mode. “Days between dates” counts the span between a start date and an end date. “Add or subtract” starts from one date and moves forward or back.
  2. Pick the dates with the date picker, or press “Use today” to start from today’s date on your device.
  3. Set the counting rule. Switch on “Include the end date” to count both the first and the last day. In the second mode, switch on “Business days only” to skip Saturdays and Sundays.

The preset counts from Thursday, November 12, 2026 to Friday, December 25, 2026: 43 days, which is 1 month 13 days or 6 weeks 1 day, with 31 weekdays and 12 weekend days among them. Public holidays such as Thanksgiving are not taken out, because holiday calendars differ by country, state and employer.

This page counts calendar days only. For hours and minutes between two clock times, use the time duration calculator.

How to count the days between two dates

The number of days between two dates is the end date minus the start date, the same rule as Excel’s DAYS function. By hand, count the days left in the starting month, add the days in each full month in between, and then add the day number of the end date.

Microsoft’s example runs from February 1 to March 15, 2021:

PieceDays
February 1 to March 1 (February 2021 has 28 days)28
March 1 to March 1514
Total42

Its second example, January 1 to December 31, 2021, gives 364: a 365-day year minus the starting day. The calculator does the same subtraction with a serial day number for every date, the way spreadsheets store dates, so it works across any number of years and leap days.

The months-and-days card counts whole calendar months from the earlier date, then the days left over. When the start date is late in a long month, the leftover days can look odd: January 31 to March 1, 2026 is 1 month 1 day, because one month after January 31 is February 28.

Should the end date be included?

Subtraction counts the nights between two dates, not the dates themselves. Monday to Friday of the same week is 4 days apart, but a vacation or a leave that runs Monday through Friday uses 5 days, because both the first and the last day count. Switch on “Include the end date” for that kind of question; it adds 1 to the total.

As a rule of thumb, leave the switch off for “how long until” and “how long ago” questions, such as days until a birthday or days since an invoice was sent. Switch it on when you are counting days of something that happens on each date, such as days of a trip, an event or a hospital stay.

Counting business days

Business days, or workdays, are Monday through Friday. Excel’s NETWORKDAYS function counts them between two dates, counting both the start and the end date, and Microsoft’s example finds 110 workdays from October 1, 2012 to March 1, 2013. With “Include the end date” switched on, the calculator gives the same 110.

The same Microsoft example then removes holidays: one holiday on a weekday brings the total to 109, and three bring it to 107. Holidays are not removed automatically here, so subtract any that fall on weekdays in your range. Weekend days are simply the total minus the business days.

Adding or subtracting days, weeks, months and years

Days and weeks are fixed lengths, so they move the date by an exact count: 90 days after November 12, 2026 is Wednesday, February 10, 2027, and a week is 7 days. Months and years are not fixed lengths, so the calculator follows the rule Excel’s EDATE function uses: keep the same day of the month. Microsoft’s example: January 15, 2011 plus one month is February 15, 2011.

When that day does not exist in the target month, the result moves to the month’s last day. January 31, 2026 plus one month is February 28, 2026; in the leap year 2028 it is February 29. February 29, 2024 plus one year is February 28, 2025. If you fill in months and days together, the months are added first and the days after.

With “Business days only”, the calculator steps through the calendar and counts only weekdays, without counting the start date, like Excel’s WORKDAY function. Microsoft’s example lands 151 workdays after October 1, 2008 on April 30, 2009, and one business day after a Friday is the following Monday.

Doing the same count in a spreadsheet

Spreadsheets store each date as a serial number, a count of days from a fixed starting date, which is why subtracting one date cell from another gives the number of days between them. The functions behind this page have direct equivalents:

QuestionExcel formula
Days between two dates=DAYS(end, start) or =end − start
Business days, both dates counted=NETWORKDAYS(start, end)
A date plus or minus whole months=EDATE(start, months)
A date plus or minus business days=WORKDAY(start, days)
Complete years or months between dates=DATEDIF(start, end, unit), with unit Y or M

Microsoft warns that DATEDIF’s “MD” option, which returns the days left after whole months, can give wrong or negative results; the months-and-days card here computes that leftover directly from the calendar instead.

Leap years and month lengths

April, June, September and November have 30 days; February has 28, or 29 in a leap year; the rest have 31. The U.S. Naval Observatory states the Gregorian rule: a year divisible by 4 is a leap year, except century years, which must be divisible by 400. So 2024 and 2028 are leap years, 2000 was one, and 1900 and 2100 are not. That gives 97 leap days every 400 years.

The calculator applies this rule to every year from 1 to 9999, extending the Gregorian calendar back before it was adopted. Dates recorded on the older Julian calendar, used before the 1582 reform, will not match.

What this calculator does not count

It counts calendar days, so it is not a due-date or age calculator. Pregnancy due dates use their own medical conventions, and age is usually stated in completed years. Legal and contract deadlines can have their own counting rules, such as skipping the day of the event or extending a deadline that falls on a weekend or holiday, so check the rule that applies. For time off measured in hours, the PTO calculator shows how paid leave accrues per pay period.

Sources & assumptions

How this calculator gets its numbers. Full method: our methodology.

  • Dates use the Gregorian calendar with its leap-year rule, for years 1 to 9999; days are whole calendar days, with no times or time zones.
  • Days between = end date − start date; including the end date adds 1. Business days are Monday to Friday among the counted dates; holidays are not removed.
  • Adding months or years keeps the day of the month and moves to the month’s last day when it is shorter. Weeks and days are added after the months.
  • Adding business days skips Saturdays and Sundays and does not count the start date.

Sources

  1. Microsoft Support (Excel), DAYS function. Days between two dates = end date − start date: February 1 to March 15, 2021 is 42 days; January 1 to December 31, 2021 is 364.
  2. Microsoft Support (Excel), NETWORKDAYS function. Whole working days between two dates, excluding weekends and any listed holidays; October 1, 2012 to March 1, 2013 is 110 workdays (both dates counted).
  3. Microsoft Support (Excel), WORKDAY function. The date a given number of working days before or after a start date; 151 workdays after October 1, 2008 is April 30, 2009.
  4. Microsoft Support (Excel), EDATE function. The date a given number of months before or after a start date, on the same day of the month (15-Jan-11 + 1 month = 15-Feb-11).
  5. Microsoft Support (Excel), DATEDIF function. Complete years (“Y”) and complete months (“M”) between two dates, and Microsoft’s warning that the “MD” leftover-days option can give wrong results.
  6. U.S. Naval Observatory, Astronomical Applications Department, Leap Years. Gregorian rule: years divisible by 4 are leap years, except century years not divisible by 400, so 1700, 1800, 1900 and 2100 are not leap years and 1600, 2000 and 2400 are (97 leap days every 400 years).

Last reviewed . Contracts, courts and agencies can count days by their own rules; check the rule that applies to your deadline.

Frequently asked questions

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

Subtract the start date from the end date. February 1 to March 15, 2021 is 28 days to March 1 plus 14 more, or 42 days. Add 1 if both the first and last day should count.

How many business days are between two dates?

Count Monday to Friday in the range. October 1, 2012 to March 1, 2013 has 110 weekdays, counting both dates. Subtract any public holidays that fall on weekdays.

What date is 90 days from today?

Add 90 days with the Add or subtract mode and press Use today. For example, 90 days after November 12, 2026 is Wednesday, February 10, 2027.

What is one month after January 31?

February 28, or February 29 in a leap year. When the same day does not exist in the target month, the result is that month’s last day, the rule Excel’s EDATE uses.

Does the calculator count the start date?

No. The 1st to the 2nd is 1 day. Switch on Include the end date to count both days, so the 1st to the 2nd becomes 2 days.

Is 2100 a leap year?

No. Century years are leap years only when divisible by 400, so 2000 was a leap year but 1900 and 2100 are not.