How to use EDATE

Need to calculate the date “x” months before or after a specific date? Use the EDATE formula in Excel.

The EDATE function returns the date after adding or subtracting the specified number of months from a given date

In our example, the specific date is 25 January 2023 and has been entered in cell D7: