adding months to an inputted date

B

BLW

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
 
P

Peo Sjoblom

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

however what do you want the date to be in C2 if B1 is
01/30/05?

Regards,

Peo Sjoblom
 
Top