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:
- March 1 to March 31 uses 30 days, leaving 60.
- April's 30 days bring you to April 30, leaving 30.
- 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.
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.
| Time from the start | Date from March 1 |
|---|---|
| 7 days | March 8 |
| 14 days | March 15 |
| 30 days | March 31 |
| 6 weeks | April 12 |
| 45 days | April 15 |
| 60 days | April 30 |
| 90 days | May 30 |
| 3 months | June 1 |
| 120 days | June 29 |
| 180 days | August 28 |
| 6 months | September 1 |
| 1 year | March 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.