date formula --save as

[everwhat]

Is there a fomula that you can place in a cell that applies the date the file is save as rather then the current date such as today() or now()?

 

[lozzablake]

I do not think there is a built-in Excel formula, but you can create a user defined formula using VBA.

Function myDateLastModified()
    Dim fso
    
    Dim f As file
    
    Set fso = CreateObject("Scripting.FileSystemObject")
    
    Set f = fso.GetFile(ThisWorkbook.FullName)
       
    myDateLastModified = f.DateLastModified
    
    Set fso = Nothing
    Set f = Nothing

End Function

you then jut call the function as normal from within the workbook. For this to run properly you need to ensure that the reference to the 'Microsoft Scripting Runtime' is ticked. If you do not know how to do this. Let me know

 

[everwhat]

What about when the file was created... is there a date formula?