Thread: Adding 5 yrs to a date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Adding 5 yrs to a date
=DATE(YEAR(G3)+5,MONTH(G3),DAY(G3))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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