dates

D

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! :)
 
L

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
 
D

donna

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

Leith Ross

Hello Donna,

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

Sincerely,
Leith Ros
 
Top