Adding years to a date

[sumitk]

Hi. Is there an Excel formula that I could use to add certain number of years
to a given date?

For example, if todays date is 04/30/06... I would like to see what the date
would be one year from now, three years from now, five years from now and so
on..

Thanks in advance.

sk

 

[David Biddulph]

Hi. Is there an Excel formula that I could use to add certain number of
years
to a given date?

For example, if todays date is 04/30/06... I would like to see what the
date
would be one year from now, three years from now, five years from now and
so
on..

=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1)) to add 3 years.

 

[Miguel Zapico]

You can use the DATE formula, something like:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

Hope this helps,
Miguel.

 

[daddylonglegs]

you could use this formula to add one year to a date in A1

=date(year(A1)+1,month(A1),day(A1))

for 3 years change the 1 to a 3

or using EDATE from analysis toolpak

=EDATE(A1,12)

for 3 years change the 12 to a 36

note: these might give different answer in some circumstances, e.g. i
A1 is a leap day, e.g. 29th February 200

 

[sumitk]

Worked like a charm. Thanks a ton!!