Date & Timebeginner
Add or subtract months from a date with EDATE
=EDATE(A2,12)
Google Sheets reference
EDATE in Google Sheets
Works in Google Sheets1 worked example
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full EDATE reference for Excel — including all worked examples, common errors, and FAQ.
EDATE Excel reference →