Thread: dates
View Single Post
  #2   Report Post  
donna
 
Posts: n/a
Default


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


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