Formula

[deaculver]

Is there a way to post a date and time in a cell or column along with a
fomula, that will update to the current date and time everytime you
adjust/change something in that cell?

 

[Gord Dibben]

Can't be done with a formula or it will update whenever calculation takes
place not just when that cell is updated.

See John McGimpsey's site for code to set a time stamp whenever a cell is
updated.

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


Gord Dibben Excel MVP

 

[Dave Peterson]

Maybe...

You may want to look at how JE McGimpsey does it (just for comparison):
http://www.mcgimpsey.com/excel/timestamp.html