In that formula you'll get a FALSE result any time Q80 doesn't equal
NOW().

You'll have to tell Excel what to display for those occasions.

If you want the cell to appear to be blank then add to the formula like
this:

=IF(Q80="closed",NOW(),"")


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