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
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
Hi,
For due date 6 months out ...base date in cell A1
Please Login or Register to view this content.
Hello Carim
My first question on this forum.
Thanks for the quick response!
Formula works great!
Pt536
Welcome to the Forum ...
Glad it fixed your problem
Thanks for the feedback
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.
Hi,
Have another try with following ...
Please Login or Register to view this content.
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?
You should only need
=DATE(YEAR(A1),MONTH(A1)+7,0)
Another attempt ...
Please Login or Register to view this content.
Thanks again for all your help!
Working all the scenerios to make sure it works..........
Carim and Daddylonglegs, Thanks for your help in solving my problem!
Everything seems to be working great now
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks