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.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=374029