Input original save date

[djarcadian]

Is there a way for a cell to display the date the excel document in question was saved?

[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"
<[email protected]> wrote
in message
news:[email protected]...
>
> Is there a way for a cell to display the date the excel
> document in
> question was saved?
>
>
> --
> djarcadian
> ------------------------------------------------------------------------
> djarcadian's Profile:
> http://www.excelforum.com/member.php...o&userid=15877
> View this thread:
> http://www.excelforum.com/showthread...hreadid=547985
>