Add 2 Years to Date in Excel

I wanted to add two years to a date in Excel. This is the formula you need

Hat tip to www.mrexcel.com, assuming your original date is in column A.

=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

Written on July 18, 2016