Microsoft KB Archive/52131

{| = Excel: Adding Years to a Date While Keeping Same Month and Day =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q52131

SUMMARY
To add a number of years to a date in Microsoft Excel so that the month and day stay the same, use the following formula

=DATE(YEAR(ref)+var,MONTH(ref),DAY(ref)) where &quot;ref&quot; gives the location of the cell where the date is to be changed, and &quot;var&quot; is the number of years to add to the date in &quot;ref&quot;. For example, to add 5 years to 4/1/90 (located in cell A1) so that 4/1/95 is the resulting date, the formula is as follows:

=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))
 * }