Any formula to insert last document saved date ?

  • Thread starter Thread starter DR
  • Start date Start date
D

DR

Hi,

We have one shared file,which is updated by every one in the Team,

I have to insert a formula in work sheet,it has to updated the Date, when it
is modified and saved. is it posible ?

Ex : I worked in the work book on 03/24/09 it has to updated the same date.

when I open the workbook it has to show the date 03/24/09 (Last saved date).
 
First enter this small UDF:

Function SavedDate() As Date
Application.Volatile
SavedDate = ActiveWorkbook.BuiltinDocumentProperties.Item(12)
End Function

Then in a worksheet cell enter:

=SavedDate() and format to date
 
Back
Top