Adding years to a date
"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
|