Add or Subtract Calendar Days From a Date
Find the date before or after a starting date by adding a signed number of days. The calendar calculation counts weekends and handles leap years.
Formula & assumptions
Result date = start date + signed day offset
Enter a negative offset to count backward. The count includes weekends and leap days.
Worked example
- Starting date
- 2026-11-19
- Days to add
- 45
- Resulting date
- 2027-01-03
Interpreting the result
A one-day offset returns the next calendar date even when that date falls on a weekend or holiday.