Thank you for your reply. I don't know how to do what you're saying?? Can
you provide steps? Also will this work for already existing documents that
were saved over a year ago?
--
Thank you for your help
MO
Albany, NY


"Gary''s Student" wrote:

Use this UDF:

Function lastsaved() As Double
lastsaved = ActiveWorkbook.BuiltinDocumentProperties(12)
End Function

So in a cell enter:
=lastsaved() and format the cell as Date.
--
Gary''s Student - gsnu200804


"MO" wrote:

Hello,
I am trying to place the last date saved in an excel spreadsheet. For
instance, if I last saved a document a month ago, and I open the document
today, I want a month ago's day to print out not today's date UNLESS I SAVE
the document.

I know this can be done in MS Word through Insert Field, choosing date and
format and preserving formatiing during updates but I cannot for the life of
me figure out how to do this in Excel.

The closest I can come is header/footer and putting date in format there but
it doesn't give me the last date I saved.

Can you help?
--
Thank you for your help
MO
Albany, NY