Thread: FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL
=DATE(YEAR(A1),MONTH(A1)+25,DAY(A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"SorianoP" wrote in message ...
|I need to create a formula to increment the date on a column by 25 months
| on another column
|


Reply With QuoteReply With Quote