How to Add Days to a Date in Excel
Simple addition, WORKDAY(), and EDATE() formulas for future and past dates.
MM/DD/YYYY
Resulting Date
Friday, December 18, 2026
ISO: 2026-12-18 · Week 51 of 2026
Adding Days, Business Days, and Months in Excel
- Add 30 Calendar Days:
=A2 + 30 - Add 30 Business Days (skipping weekends & holidays):
=WORKDAY(A2, 30, $E$2:$E$12) - Add 3 Calendar Months (with end-of-month clamping):
=EDATE(A2, 3)