How to Add a number of years to a date?

Add a number of years to a date :


To add a number of years to a date use the DATE, YEAR, MONTH, and DAY functions to do this task.


Example :

The example may be easier to understand if you copy it to a blank worksheet.

	A	B
1	Date	Years to add
2	6/9/2007	3
3	9/2/2007	5
4	12/10/2008	25

Formula	Description (Result)
=DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2))	Add 3 years to 6/9/2007 (6/9/2010)
=DATE(YEAR(A3)+B3,MONTH(A3),DAY(A3))	Add 5 years to 9/2/2007 (9/2/2012)
=DATE(YEAR(A4)+B4,MONTH(A4),DAY(A4))	Add 25 years to 12/10/2008 (12/10/2033)