=IF(Q80="closed",NOW(),"")
place this formula in Q1
format the cell for date


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=526513