Display Last Saved Date on worksheet

Question

Does anyone know how to display the Last Saved Date of an Excel Spreadsheet on one of the worksheets   I have found ways to do it using macros  but the spreadsheet is populated by an add-in called Jet Essentials  and this does not like macros so a solution here must not use one

User · Answer

May be this time stamp fit you better Code

Function LastInputTimeStamp() As Date
  LastInputTimeStamp = Now()
End Function

and each time you input data in defined cell (in my example below it is cell C36) you'll get a new constant time stamp. As an example in Excel file may use this

=IF(C36>0,LastInputTimeStamp(),"")

User · Answer

thought I would update on this   Found out that adding to the VB Module behind the spreadsheet does not actually register as a Macro   So here is the solution    Press ALT   F11 Click Insert   Module Paste the following into the window    Code  Function LastSavedTimeStamp   As Date   LastSavedTimeStamp   ActiveWorkbook BuiltinDocumentProperties  Last Save Time   End Function    Save the module  close the editor and return to the worksheet  Click in the Cell where the date is to be displayed and enter the following formula    Code   LastSavedTimeStamp

User · Answer

This might be an alternative solution  Paste the following code into the new module    Public Function ModDate   ModDate    Format FileDateTime ThisWorkbook FullName    m d yy h n ampm    End Function   Before saving your module  make sure to save your Excel file as Excel Macro-Enabled Workbook    Paste the following code into the cell where you want to display the last modification time      ModDate     I d also like to recommend an alternative to Excel allowing you to add creation and last modification time easily  Feel free to check on RowShare and this article I wrote  https   www rowshare com blog en 2018 01 10 Displaying-Last-Modification-Time-in-Excel

User · Answer

There is no built in function with this capability  The close would be to save the file in a folder named for the current date and use the  INFO  directory   function

User · Answer

You can also simple add the following into the Header or Footer of the Worksheet Last Saved   amp  Date   amp  Time

[excel] Display Last Saved Date on worksheet

Examples related to excel