Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Update date and time in Excel DocumentPosted 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.
Re: Update date and time in Excel DocumentPosted by Greg Collett on September 28, 2001 1:23 PM
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
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.