Auto Populate Last Saved Date in an Excel Spreadsheet
I have a shared excel spreadsheet that gets updated frequently. I wanted an easy way to auto-populate a cell with the last updated date. I did a little searching and came across a pretty straight forward VBA Macro. With a little bit of modification, cell A1 always shows the correct last updated date.
Excel > Developer > Visual Basic > New Module
Function LastSavedDate()
LastSavedDate = ActiveWorkbook.BuiltinDocumentProperties(12)
End Function
Excel > Cell A1
=CONCATENATE(“Last update: “,TEXT(LastSavedDate(),”mm/dd/yyyy”))
Simple as that!