Open Close Name
03/06/08 03/07/08 mveach
04/01/08 04/07/08 mveach
04/05/08 05/12/08 mveach
04/14/08 04/18/08 mveach
04/14/08 04/15/08 mveach
04/26/08 04/28/08 mveach
04/27/08 01/00/00 mveach
04/28/08 mveach
04/28/08 mveach
04/28/08 mveach
04/28/08 04/28/08 mveach
04/29/08 05/12/08 mveach
05/09/08 05/13/08 mveach

There are three records that are missing a close date... i want to create a
formula that says: if a cell is empty then autofill with todays date and fill
the cell red( if cell has a close date leave as is). Thanks
--
sss