dates

[donna]

I am trying to make it so that if a client enters a date, excel will automatically calculate several due dates. I am very new to all of this so answers will need to be very specific.
I want to have a client enter a date in H7 and have excel come up with a date in H10, H12, H14 etc (30 days, 45 days, 90 days etc).
Can anyone help? Ta!

[Leith Ross]

Hello Donna,

Place the following Formulas in the indicated Cells...

H10 =IF(H7, H7 + 30, "")
H12 =IF(H7, H7 + 45, "")
H14 =IF(H7, H7 + 90, "")

Sincerely,
Leith Ross

[donna]

Thanks for your help Leith. What do I put in cell H7? See, I told you I am an extreme novice!!

[Leith Ross]

Hello Donna,

In your original post you said the user would enter a date in this cell. If the cell location is different, chage H7 in each of the formula to the new cell that will hold the date.

Sincerely,
Leith Ross

[donna]

Hey Leith - I left D7 blank and entered the formula in the other cells. The only thing is that it comes up with a date code ie 38507. How can I change this to show the date ie July 30, 2005. Thanks a lot for your help!!

Donna
from BC

[donna]

I have finally figured out how to do this and everything works fine except for one thing. When I remove a date from what is now D7 all the other cells (D10,D14, D16 etc) show the word "false". The word "false" only disappears when I enter a date into D7. Since the user is going into the document with nothing in D7 I want the other cells to be blank as well. This is the coding that I used - [cell D10] =IF(D7,D7+30), [cell D12] =IF(D7,D7+45), [cellD14]=IF(D7,D7+60).......
Can anyone help?

thanks a million!

donna

[Cutter]

You need the 2 quotation marks that Leith showed you.

Instead of your formula in D10 being =if(D7,D7+30)
you have to change it to =IF(D7,D&+30,"")

The IF formula needs to know what to do for True (that's the D7+30) part and what to do for False (that's where the "" comes in). The double quotations is Excel's way of saying make the cell blank.

And I assume you got the date code formatted to show the date the way you want it.

[donna]

Thank you so much Cutter! Worked like a charm and now I am good to go! And yes, I did figure out the date code format part on my own.

[Cutter]

You're quite welcome. Always glad to help a fellow Canuck.