help with due dates!

[pt536]

What is the formula to calculate a due date from a date in another cell?
If the date is 06-12-06 and the due date is the end of the month six months later, 12-31-06, how do I do this?

thanks

[Carim]

Hi,

For due date 6 months out ...base date in cell A1

Please Login or Register  to view this content.

[pt536]

Hello Carim

My first question on this forum.
Thanks for the quick response!
Formula works great!

Pt536

[Carim]

Welcome to the Forum ...
Glad it fixed your problem

Thanks for the feedback

[pt536]

Mostly fixed......
If the date is from the 1st to the 14th the formula gives me a due date of 5 months, if the date is 15th to 31st then I get a due date of 6 months. Somewhere the formula is rounding down instead of always rounding up.......

Thanks again.

[Carim]

Hi,

Have another try with following ...

Please Login or Register  to view this content.

[pt536]

Hello again...hate to keep bugging you....
Getting closer....works great months 1 through 7 (adds 6 months) but months 8 through 12 it adds 18 months?

[daddylonglegs]

You should only need

=DATE(YEAR(A1),MONTH(A1)+7,0)

[Carim]

Another attempt ...

Please Login or Register  to view this content.

[pt536]

Thanks again for all your help!
Working all the scenerios to make sure it works..........

[pt536]

Carim and Daddylonglegs, Thanks for your help in solving my problem!
Everything seems to be working great now

[shereif]

Hello,
Mr. (Carim)..
this is my first time to the forums.
I would really appreciate if you can make it in an Excel sheet and send it or post it..
I tried to do it as per your instructions, but it did not work for me...
my Excel is 2010 version.
THANKS