Thread: how do i add 1 year to a date formatted cell?
View Single Post
  #1   Report Post  
rogerm
 
Posts: n/a
Default how do i add 1 year to a date formatted cell?
I would like to increase the year in a MM/DD/YYYY formated cell by 1, 2,5 and
10 and place the new dates in other cells. Adding 365 doesn't work because
of leap years. Any suggestions?
Reply With QuoteReply With Quote