adding months to an inputted date
 

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

=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

"BLW" wrote:

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

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

Sorry. +2 of course.

Best wishes Harald

"Harald Staff" skrev i melding
...
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

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

Since he's adding 2 months, you probably meant 12/30/2005, no?

Correct <g

--
Regards,

Peo Sjoblom

(No private emails please)


"Myrna Larson" wrote in message
...
however what do you want the date to be in C2 if B1 is
01/30/05?

Since he's adding 2 months, you probably meant 12/30/2005, no?