EDATE

Definition: EDATE is a function that returns the serial number of the date that is a specified number of months before or after a specified date.

Syntax: =EDATE(start_date, months)

Situation: This formula is suitable when you need to find a date that is a specified number of months before or after a specified date.

Example: If you have a start date January 1, 2021 and want to find the date that is 6 months after that, the formula =EDATE(“1/1/2021”, 6) can be used, which returns July 1, 2021.