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
|