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)) If you're new here, you may want to subscribe to my RSS feed or learn more about me, Ben Hamilton or link to me via LinkedIn. I can be found tweeting at @benhamilton. Thanks for visiting!