|
date
If have three columns. One which reflect the status of the record. OK/NOK.
Every time I change the status, excel has to adapt the date and hour in respectively column 2 and 3.
which formula do I have to use?
note that only the date of the changed record may be adapted, and not date of the other records.
thanks in advance.
david
|