Input original save date

D

djarcadian

Is there a way for a cell to display the date the excel document i
question was saved
 
C

Chip Pearson

Only with a VBA function. Put the following code in a standard
code module.

Function SaveDate()
SaveDate = Format(Application.Caller.Parent.Parent. _
BuiltinDocumentProperties("Last Save Time"), "short date")
End Function

Then call the function from a worksheet with

=SaveDate()


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"djarcadian"
in message
news:[email protected]...
 
Top