Returns a date a specified number of months before or after another date.
Description
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.
1Better Sheets Tutorial