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

"sumitk" wrote in message
...
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.
--
David Biddulph

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

Hope this helps,
Miguel.

"sumitk" wrote:

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

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. if
A1 is a leap day, e.g. 29th February 2008


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=543454

Worked like a charm. Thanks a ton!!

"daddylonglegs" wrote:


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. if
A1 is a leap day, e.g. 29th February 2008


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=543454