Last Updated Date & time in Cell

hi, i want to know whether there is any formula for displaying the last date & time of the file saved.

A UDF is required for this.
Place this in a Normal VBA Module

Please Login or Register  to view this content.

Then in excel enter the formula

=ModDate()

Ok.Thanks for the solution.
Hmmm any other alternate for this using formula

hello davesexcel,i had a little problem with the solution.its not updating the time of last saved.When ever i Save the file>> Close it >>> Re-open it>>.its showing the first saved time only.I think it should show the new changes also dynamically.plz help

If there is a Built in worksheet function, I can't find it.

The function has to be initiated each time the workbook is opened, possibly using this

=moddate()+0*NOW()

The Now() will ensure the worksheet calculates, updating the moddate.

Dave, if you combine it with NOW(), wouldn't that produce the same effect as using Application.Volatile in the function?

To tell the truth, I thought it was in there, but just not working

Please Login or Register  to view this content.

Although these seem to work even this would work to get the time last modified.

Please Login or Register  to view this content.

This is macro driven so just run the macro to get the last date modified.

Running the macro or using the UDF the workbook would be considered changed, and want to save, even if you did not make any real changes.

Placing this code in the Workbook_BeforeSave may be a better idea

Please Login or Register  to view this content.

or another option is to decide if you want to record the time when you close the workbook

Please Login or Register  to view this content.

Hi,

Maybe one of these might help?

http://excel.tips.net/Pages/T002190_..._a_Footer.html

http://excel.tips.net/Pages/T003352_...st_Edited.html