In the example shown, the formula in D5 is:

Adding years

To move forwards and backwards in years from a certain date, you can multiply by 12 inside EDATE like this:

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.