Add LastFileDate update date in cell

[Pablo2000]

I would like a cell to display the computer date of the last updated date of my excell file. Looking at MS I am told to use...


=FileDateTime("D:\2_Excel_Documents\BudgetSheet.xl sx")

But instead I get #NAME?

Has MS got it wrong?

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-display-the-last-updated-date-of-a-source/898699fc-2b2e-49ea-89a0-1441c833c98c

[Pecoflyer]

If you read the entire article you will see that FileDateTime is a VBA function, not a regular one

[Pablo2000]

Okay Pecoflyer what is the answere!

[Pecoflyer]

How to Insert Last Modified Date and Time in Excel Cell

[Pablo2000]

THat is for the time an actual cell is updated. I want the actual timestamp of the excell spreadsheet.

[Pecoflyer]

First method is entitled : Using the File Tab to Get the Last Modified Date and Time of the File

Is that not what you need?

[Pablo2000]

No. I was hopping for an excell spread sheet to populate this for me to see rarther than diging it out of the settings tab.

[Pecoflyer]

A small " thank you for trying" with have been nice. Good luck with your quest

[Alansidman]

Will the last saved date and time work for you?

If yes, then

Sub LastSaved()
    Dim x As Date
    x = ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
    MsgBox (x)
End Sub

Also, have you looked at this link-->https://techcommunity.microsoft.com/...a-cell/3690222