This might help

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

Regards
Rowan

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