View Single Post
  #5   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi Logan

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

HTH. Best wishes Harald

"BLW" skrev i melding
...
I need a function that will take a date that a user has typed in a

different
cell and will then add two months to the date. For instance, if I type
"2/12/05" in B1, then I want C2 to be: "4/12/05". Thank you for any help
that you may be able to give.

Logan