tips

Auto Populate Last Saved Date in an Excel Spreadsheet

 in Tech  tagged excel / macro / productivity / tips / vba by

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!

 

References: