Returns a date a specified number of months before or after another date.

How To Use in Sheets

EDATE(start_date, months)

External Links

How to use the EDATE function to add or subtract months in Sheets

The EDATE function takes a starting date and a number of months as its input. It then increments (or decrements) the date by the number of months you specify. Learn how to use it correctly, as dates require special care when used in formulas. They don't behave as regular numbers do in spreadsheets.