dates
 

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


--
donna
------------------------------------------------------------------------
donna's Profile: http://www.excelforum.com/member.php...o&userid=23725
View this thread: http://www.excelforum.com/showthread...hreadid=374029

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=374029

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


--
donna
------------------------------------------------------------------------
donna's Profile: http://www.excelforum.com/member.php...o&userid=23725
View this thread: http://www.excelforum.com/showthread...hreadid=374029

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=374029