Inserting dates
Try this:
=IF(A11,NOW( ),0)
It will place the current date in B1.
Not sure if that is what you mean by 'Not Change'.
Corey....
"JDay" wrote in message
...
If anything appears in cell A1, I want the date to appear in cell B1 but
not
upate. I would like that date to remain the same and not change (update).
|