update a date cell only when worksheet is edited

[Joe Black]

Hi. is there a function that updates the date cell automatically only when
the worksheet is edited or something to that effect. thank you

 

[Rowan]

This might help

http://www.mcgimpsey.com/excel/timestamp.html

Regards
Rowan