Add/Subtract Days Calculator
Add or subtract days, weeks, months, or years from a date
How It Works
Overview
The Add/Subtract Date Calculator shifts a starting date forward or backward by a specified number of days, weeks, months, or years. It applies the same calendar arithmetic that powers spreadsheet functions like DATE, EDATE, and WORKDAY — useful for project deadlines, contract end dates, gestation calculations, prescription refills, or any planning task where you know one anchor date and a duration.
Behind the scenes the calculator counts calendar days, so weekends and public holidays are included in the total. Months and years are handled with month-end clamping (adding 1 month to January 31 gives February 28 or 29) and full leap-year awareness, so anniversaries and annual renewals land on the correct date even across 2024, 2028, and other leap years.
The Formula
The unit determines how the offset is applied:
- Days — increments the calendar day directly (handles month/year rollover).
- Weeks — equivalent to multiplying the amount by 7 days.
- Months — increments the month component; clamps to the last valid day if the destination month is shorter.
- Years — increments the year component; February 29 rolls back to February 28 in non-leap years.
Calendar arithmetic is non-commutative: adding 1 month then subtracting 1 month doesn't always return the original date if the start day is 29, 30, or 31. The calculator follows the ISO/CLDR convention used by date-fns and most spreadsheet engines.
Worked Example
Suppose a 90-day return window starts on a purchase made on January 31, 2026:
- Start date: January 31, 2026 (Saturday)
- Operation: Add
- Amount: 90, Unit: Days
- Result date: May 1, 2026 (Friday)
Compare against adding 3 months instead. From January 31, +3 months lands on April 30, 2026 (clamped from "April 31" which doesn't exist). The 1-day gap between these two answers is exactly why retailers spell out "90 days" on receipts rather than "3 months."
When to Use This
- Project deadlines. Kickoff was March 3 and the contract gives you 45 working-equivalent calendar days — find the due date instantly.
- Pregnancy and gestation. Add 280 days (40 weeks) to the last menstrual period to get the estimated due date.
- Subscription and trial expirations. Add 14 days, 30 days, or 1 year to the signup date to know when to remind a customer.
- Legal notice periods. Add 30 or 60 days to the notice date to find the earliest valid termination date.
- Backward planning. Subtract 6 weeks from a wedding date to know when invitations should be mailed.
- Medication refills. Add 30 or 90 days to the last fill date to schedule the next pharmacy visit.
Common Mistakes to Avoid
- Confusing "in 30 days" with "next month." They differ in months with 28, 29, or 31 days. For SLAs and contracts, always specify days.
- Ignoring weekends in legal deadlines. Many jurisdictions push a deadline that lands on Saturday or Sunday to the next business day — verify the rule before relying on calendar arithmetic.
- Off-by-one errors on the start date. Decide whether the start date counts as day 0 or day 1. A 30-day return policy purchased June 1 typically expires July 1, not June 30.
- Forgetting leap years on multi-year calculations. 4 years is 1,461 days, not 1,460, because of the leap day.
- Mixing months and days for billing. Monthly billing cycles use months; daily proration uses days. Pick one and stick with it across an invoice.
Frequently Asked Questions
Ad Space