About the Add or Subtract Days
This add or subtract days calculator shifts a date by any amount in days, weeks, months or years and returns the result in several formats at once: ISO 8601, US and European ordering, the day of the week, the number of days actually shifted and the ISO week number the result falls in. Subtracting works by entering a negative amount rather than switching mode. Month and year arithmetic clamps to the end of the target month, so adding a month to 31 January gives the last day of February rather than spilling into March.
How to use the Add or Subtract Days
- 1
Enter the Start date to shift from.
- 2
Type an Amount, using a negative number such as -45 to subtract instead of add.
- 3
Choose the Unit — Days, Weeks, Months or Years.
- 4
Read the resulting date and the Formats panel for the ISO, US and European renderings, the weekday and the ISO week.
What people use it for
Finding a contractual deadline
A 90-day payment term or a 30-day cancellation window resolves to an exact date, and the weekday reading tells you immediately if it lands at the weekend.
Scheduling recurring reviews
Adding six months or one year to a start date gives the correct anniversary even when the original date is at the end of a long month.
Backdating from a fixed event
Working backwards from a launch or a wedding with a negative amount finds when each preparation milestone has to begin.
Calculating expiry and retention dates
Document retention policies and warranty periods are usually written in years, so shifting by years gives the exact expiry date for a record.
How month-end clamping works
Adding one month to 31 January has no obviously correct answer, because 31 February does not exist. There are two established behaviours. Overflow lets the surplus roll into the next month, giving 3 March in a common year, which is what naive date arithmetic produces and almost never what anyone wanted. Clamping caps the result at the last valid day of the target month, giving 28 February or 29 February in a leap year. This tool clamps, matching the behaviour of most date libraries, spreadsheet EDATE functions and the way people reason about monthly billing. The consequence is that month arithmetic is not reversible: 31 January plus one month gives 28 February, but 28 February minus one month gives 28 January rather than returning you to the 31st. It is also why adding one month twelve times can land on a different date from adding twelve months once, and why subscription systems store the original day of month separately rather than repeatedly adding to the previous result.
Calendar days against elapsed time
This tool works in calendar days, not in fixed 24-hour blocks, which is the right model for anything a human reads off a calendar. The distinction matters whenever daylight saving is in play. In a timezone that observes it, two days of the year are not 24 hours long — one is 23 hours and one is 25 — so adding 48 hours to a date can land on a different calendar day from adding two days. Financial and legal deadlines are almost always expressed in calendar days, which is why date libraries separate a calendar-day addition from a duration addition and why the two produce different answers across a transition. The days-shifted figure in the Formats panel confirms the actual calendar days moved, which is worth checking after a months or years shift where clamping means the number is not what a simple multiplication would predict.
Tips
- Enter a negative amount to subtract; there is no separate mode to switch into.
- Check the day of week on the result — a deadline landing on a Saturday usually needs moving.
- This shifts calendar days and does not skip weekends; use the business days calculator when working days are what count.