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
what I thought
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))