View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Formula that displays the documents modified date

Try this tiny UDF:

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


--
Gary''s Student - gsnu200781


"raisorpr" wrote:

Is there a formula that displays an excel documents modified date?

=today() displays the current date but I'm looking for a way to display in a
cell the date the document was last modified.

can someone help?
--
Thanks,
raisorpr.