fx =EDATE(A1,3)ABCProject A2026-01-1573 daysProject B2026-02-2037 daysProject C2025-12-01118 days
📅 Date

EDATE Formula for Date

Add or subtract months from a date. Copy-paste ready for Excel, Google Sheets, and Airtable.

=EDATE(A1,3)
When you need this: When you sign a contract (A1 = 2024-01-15) for 1 year and need the renewal date automatically (add 12 months).

How it works

  1. 1EDATE takes a start date (A1) and months to add (3).
  2. 2Adds (or subtracts if negative) that many months.
  3. 3Handles month-end edge cases (e.g., Jan 31 + 1 month = Feb 28).

Variations

Subtract 6 months
=EDATE(A1,-6)
Add months for payment schedule
=EDATE(TODAY(),3)

Related Formulas

TODAY / NOW — Get current date or date/timeDateDATEDIF — Calculate difference between two datesDateNETWORKDAYS — Count business days between two datesDateYEAR / MONTH / DAY — Extract year, month, or day from a dateDate

Need a formula that's not here?

Generate custom formula →