Google Sheets - EDATE function
EDATE function shifts a date by a certain number of months. Syntax EDATE(date, number_of_months) Example Notes If the number of months is positive, EDATE function shifts a date to the future. If the number of months is negative, EDATE function shifts a date to the past. If the number of months is decimal such as 1.8, the decimal part will be dropped, so 1.8 is equivalent as 1.