adding months to an inputted date

[Guest]

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

 

[Guest]

=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

 

[Harald Staff]

Hi Logan

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

HTH. Best wishes Harald

 

[Harald Staff]

Sorry. +2 of course.

Best wishes Harald

Hi Logan

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

HTH. Best wishes Harald

 

[Myrna Larson]

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?

 

[Peo Sjoblom]

Correct <g>

--
Regards,

Peo Sjoblom

(No private emails please)