When 12 is given for months, EDATE gets the same date next year.
Get same date next year
To get the same date next year from a given date, you can use the EDATE function. In the example shown, the formula in cell B5 is: =EDATE(B5,12)
When 12 is given for months, EDATE gets the same date next year.
