Date Calculator: Add or Subtract Days From a Date
By TheToolsBank Editorial TeamLast updated:
Pick a start date and add or subtract any number of days, weeks, months, years or business days to find the resulting date. For example, 90 days from January 1 is April 1 (in a non-leap year). Use it for deadlines, notice periods, due dates and delivery dates. Quick answers for 30, 60, 90 and 180 days from today are listed on this page too, based on your device's date. Need the number of days between two dates instead? Use the Date Difference Calculator.
How the Date Calculator works
Pick a start date, choose Add or Subtract, enter an amount, and choose a unit — days, weeks, months, or years — or switch to business-day mode to skip weekends automatically. Press Calculate to see the exact resulting date and its day of the week.
Calendar units vs. business days
Calendar mode adds or subtracts a fixed span of time exactly as written on a calendar — 90 days is always 90 days, regardless of weekends. Business-day mode instead counts only Monday through Friday, skipping every Saturday and Sunday, which better reflects deadlines quoted in 'business days' rather than calendar days.
How month and year additions handle short months
Adding months or years uses standard calendar arithmetic. If the resulting month is shorter than the start day (for example, adding one month to January 31st), the date rolls forward into the next month, the same way most calendar and spreadsheet software handles it.
Why 90 Days Is Not the Same as 3 Months
Months have different lengths, so 90 days and 3 months only match by coincidence. Adding 3 months to January 1 gives April 1, which is 90 days later in a non-leap year but 91 days in a leap year. Choose days when a contract or deadline counts days, and months when it counts calendar months.
Need the number of days between two dates instead? Use the Date Difference Calculator.
Example: common durations from 22 October 2026
| Add | Result | Note |
|---|---|---|
| 30 days | Saturday, 21 November 2026 | Lands on a weekend |
| 60 days | Monday, 21 December 2026 | |
| 90 days | Wednesday, 20 January 2027 | 90 days = 12 weeks and 6 days |
| 6 months | Thursday, 22 April 2027 | Same day of the month |
| 180 days | Tuesday, 20 April 2027 | 2 days earlier than 6 months |
| 10 business days | Thursday, 5 November 2026 | Weekends skipped |
How to add days to a date in Excel or Google Sheets
Dates are numbers in spreadsheets, so adding days is simple. With the start date in cell A1:
| What you want | Formula (Excel and Google Sheets) |
|---|---|
| Add 90 days | =A1+90 |
| Subtract 45 days | =A1-45 |
| Add 3 months | =EDATE(A1, 3) |
| Add 10 business days | =WORKDAY(A1, 10) |
| Add 10 business days, skipping holidays | =WORKDAY(A1, 10, H1:H12) (H1:H12 = your holiday dates) |
One difference to know: when you add one month to 31 January, Excel’s EDATE stops at 28 February (the last day of the month), while this calculator rolls forward into early March, as explained above. Check which rule your contract or system uses if the exact day matters.
Counting working days with holidays? Use the Business Days Calculator. Planning a year? See How Many Work Hours Are in 2026?
Common Mistakes to Avoid
Assuming 'business days' and 'calendar days' are interchangeable
Solution:
Forgetting the start date itself doesn't count as day one
Solution:
Not accounting for month-length differences
Solution:
Using calendar mode when a holiday-aware business-day count was needed
Solution:
Entering a negative amount instead of using the Subtract option
Solution:
Confusing weeks with a fixed 7-day multiple of business days
Solution:
Frequently Asked Questions
Set today’s date, choose Add, enter 6 and pick Months. Six months keeps the same day of the month (22 October becomes 22 April), which is not the same as adding 180 days.
90 days is 12 weeks and 6 days, just under 13 weeks.
Excel’s EDATE function caps the result at the last day of the shorter month (28 or 29 February), while this calculator rolls the extra days into March. Both are valid conventions; use the one your contract or software expects.

