There is no built-in function to do this.
A user designed function (UDF) is necessary.
'--------------------
'Place the following code in the "ThisWorkbook" module...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.OnTime Now, ThisWorkbook.Name & "!TimeSaved"
End Sub

'Place the following code in a standard module...

Sub TimeSaved()
Dim strPath As String
strPath = ActiveWorkbook.Path
Range("B4").Value = "Last saved: " & FileDateTime(strPath)
End Sub
'--------------------

Every time the workbook is saved, the saved date and time will appear
in Cell B4 on the currently active sheet.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"tommy20" wrote in message...
This sounds awfully basic, but for the life of me, I can't figure out
how to do it.
I would like the date at the top of my spreadsheet to reflect the last
save date for the file. Isn't there a function that will handle this?