Cell with the date of most recent update

[kent81]

Hi everyone,

I'm just trying to find a formula that will record the date of the most recent update to the spreadsheet.

Basically I have a bunch of information and at the top of the page I have a title similar to 'Last Update on'

Does anyone know of such a formula???

I'm currently using Excel 2003.

Thanks everyone

 

[Jon von der Heyden]

Place the following in a standard module in your workbook:

Public Function LastModified() As Variant
    Application.Volatile
    LastModified = CVErr(xlErrNA)
    On Error Resume Next
    LastModified = FileDateTime(ActiveWorkbook.FullName)
    On Error GoTo 0
End Function

You can call this as a worksheet function in your workbook, e.g:
=LastModified()

 

[kent81]

Works perfectly!

Thanks very much - your a legend