Thanks but even with the formula option it only works when I have my macros
on. Is there a way round this?

"Niek Otten" wrote:

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jen2018" wrote in message
...
Hi

Is there a way to insert the current date into a cell in column D when a
cell on the same row is changed?

I need a method that doesn't involve a macro as many people will be
updating
the spreadsheet and won't enable their macros