View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default 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