Thread: Adding 5 yrs to a date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Adding 5 yrs to a date
One way:

A1: Current Date
B1: =DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))

In article ,
mazalam wrote:

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