Ben Hamilton

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))

This entry was posted in How to and tagged . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Both comments and trackbacks are currently closed.