If you don't want to use macro's, you're very limited.

You could write a function that sets the date, but this date will not be
fixed and will change (the TODAY() function for instance).

Also, you will need to drag down that formula far enough to be sure to cover
enough rows. Not very appealing I guess.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"jen2018" wrote:

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