Hello,

I would like to be able to have the following happen. If Part # cell is
blank then Completed Date is blank, but if a value is entered into the part #
cell I would like to have the current date appear in the Completed Date cell,
and to stay that date. Currently once midnight comes the date changes.

Sample chart:
Part # Request Date Completed Date

1234 April 23/06

Thanks