How to Add a number of years to a date?

by Sanju 2009-05-11 11:13:19

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.

AB
1DateYears to add
26/9/20073
39/2/20075
412/10/200825


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




Tagged in:

1162
like
0
dislike
0
mail
flag

You must LOGIN to add comments