You could use a worksheet_change event that clearscontents of the original
cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike" wrote in message
...
I have office excel 2007. I am a fairly new user,
I have a worksheet which maintains and monitors the movement of various
units, and is controlled by quantity and dates.
What I would like to do is write a formula that will remove the ordered
date when I input the new start date, which would be the newer date. So
far I have not been able to make this work.
I would appreciate any help or advice you can give me.

Many Thanks
Mike