MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Update date and time in Excel Document


Posted by Vu Dinh on September 28, 2001 12:25 PM

How to set up function for update the dates, times in Excel document? Every time when I make any changes in this document, I want to know automatically the date and time when I make that change.
thanks,
Vu Dinh


Posted by Greg Collett on September 28, 2001 1:23 PM


Vu

Try to use the =Now() function. It records the date and time that the workbook is opened or calculated.

It can be incorporated into a macro but you have to be careful that it does not become unstable if you use a cell change macro.


Hope this helps

Cheers


Greg