Thread: Adding 5 yrs to a date
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Adding 5 yrs to a date
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))
--
David Biddulph

"mazalam" wrote in message
...
How can I add 5 yrs to an existing date using a formula?

Current Date Desired Date
09/25/2007 09/25/2012


Thanks for your time....


Reply With QuoteReply With Quote