Hi all,

Just a little help - hopefully this is a simple one. When someone enters data in a cell, I would like to record the date and time this was done in the adjacent cell.

I can use -

=IF(A1="Y",NOW(),"Not Complete")

But this will auto update. I want the date and time to be fixed once the cell has been updated.

Any help, as always, will be massively appreciated!

Cheers

Rob