Date Calculator: Add or Subtract Days

Find the date that falls any number of days, weeks, months or years before or after another date, with the weekday included.

Pick a date

Add or subtract
Amount to add or subtract

Pick a start date

No date yet

Choose a start date and the amounts to add or subtract, and the new date appears here.

Calendar days apart
0 days
Day of the year
0
ISO date
None

In Excel or Google Sheets

Counting working days only? Use the business days calculator.

How does this date calculator work?

It adds or subtracts the years and months first, then the weeks and days, and shows the date you land on with its weekday.

Years and months move by calendar months rather than blocks of 30 days. When the new month is too short for the day you started on, the result stops on that month's last day, so January 31 plus one month is the last day of February. The start date counts as day zero, which means 1 day after a Monday is Tuesday. The calculator runs in your browser and gives the same answer in every time zone.

How do you add days to a date?

Count forward one month at a time: use up the days left in the current month, step through whole months, and finish in the month where the count runs out. Here is how 90 days after March 1 reaches May 30:

  1. March 1 to March 31 uses 30 days, leaving 60.
  2. April's 30 days bring you to April 30, leaving 30.
  3. Thirty more days lands on May 30.

So 90 days after March 1 is May 30, in any year.

The same method works across the end of a year. Remember that February has 29 days in a leap year, so a count that runs through it lands one day earlier than it would in a common year.

How do you add months or years to a date?

Move the month or year forward and keep the same day of the month, unless that day doesn't exist in the new month; then use the month's last day.

Two bars that both start on March 1: adding 3 months ends on June 1, 92 days later, while adding 90 days ends on May 30, two days earlierAdd 3 monthsJune 1Add 90 daysMay 30Mar 1Apr 1May 1Jun 1
From March 1, three months reach June 1, while 90 days stop at May 30.

That's why adding months and adding days can disagree: three months after March 1 is June 1, which is 92 days later, not 90. January 31 plus one month is February 28, or February 29 in a leap year, and February 29 plus one year is February 28. Excel's EDATE function follows the same month-end rule, so the calculator's answers match it.

What date is 30, 60 or 90 days from today?

The table counts forward from today's date on your device, so it stays current; for any other start date, use the calculator above.

Counted from March 1
Time from the startDate from March 1
7 daysMarch 8
14 daysMarch 15
30 daysMarch 31
6 weeksApril 12
45 daysApril 15
60 daysApril 30
90 daysMay 30
3 monthsJune 1
120 daysJune 29
180 daysAugust 28
6 monthsSeptember 1
1 yearMarch 1 of the next year

Return windows, notice periods and payment terms are often written this way. If a deadline counts business days instead of calendar days, it lands later, so check which kind the rule means.

How do you subtract days from a date?

Count backward the same way, one month at a time. For 30 days before December 25, going back 25 days reaches November 30, and 5 more reaches November 25.

Choose Subtract in the calculator to count back from a deadline, for example to find when to send a notice that needs 45 days' warning, or to work out the start of a 90-day window that ends today.

What if you need business days instead?

Use the business days calculator when weekends and holidays shouldn't count, because a calendar-day answer lands too early for most work deadlines.

The business days calculator skips Saturdays, Sundays and US federal holidays, counts the working days between two dates, and finds the date a set number of business days away. To count the calendar days between two dates instead, use the day counter.

More questions about adding and subtracting dates

Does the start date count as day 1?

No. The start date is day zero, so 1 day after Monday is Tuesday, and 7 days after Monday is the following Monday.

What is 6 weeks from today?

Six weeks is 42 days. Enter 6 in Weeks or 42 in Days, or check the 6 weeks row in the table above, which always counts from today.

How do I add days to a date in Excel or Google Sheets?

Add the number to the date: =A2+90 gives the date 90 days after the date in A2. For months, use =EDATE(A2,3), and format the cell as a date if you see a plain number.

Why doesn't adding a month always add 30 days?

Months run from 28 to 31 days. One month after March 15 is April 15, 31 days later, while one month after April 15 is May 15, only 30 days later.

Does it handle leap years?

Yes. February 29 counts when it falls inside the span, and adding a year to February 29 lands on February 28.

How far back or forward can it go?

Any date from the year 1 to the year 9999 on the Gregorian calendar. For dates before 1900 it hides the spreadsheet formula, because Excel can't work with dates that early.