View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan
 
Posts: n/a
Default Last Modification Date

You can't do it with a formula, you'd need VBA code like in 'This Workbook'

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Sheet1.Range("A1") = Date
End Sub

Regards,
Alan.

"Hal" wrote in message
...
I would like to create a formula that puts the date the file was last
saved/updated.

Any help is appreciated

Hal