Add months to date

Generic formula
=EDATE(date,months)
Summary
To add a given number of years to a date, you can use the EDATE function.
In the example shown, the formula in D5 is:
=EDATE(B5,C5)
Explanation
The EDATE function is fully automatic. Simply supply a valid date and a number of months and EDATE will return a new date. To subtract months from a date, supply a negative value.
Adding years
To move forwards and backwards in years from a certain date, you can multiply by 12 inside EDATE like this:
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.