Thread: Help w/formula to add 1 year to cell (date done) date due?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Help w/formula to add 1 year to cell (date done) date due?
Hi,

=DATE(YEAR(TODAY())+1,MONTH(TODAY()),DAY(TODAY()))

should do the job ...

HTH
Cheers
Carim

Reply With QuoteReply With Quote