Excel’s Last Modified Date FunctionIf you simply want to see the creation time and last modification time in Excel (for Excel 2016), the way to do it is just to:
- Click on “File”
- Select “Info”
- Find the information you need under the “Related Dates” section
But, if you want to go as far as inserting last modification time, please note that in Excel, there is no feature to do it. You need to use Excel VBA function. Open your Excel file and do the following steps:
- In your Excel worksheet, cllick on ALT + F11 to open the Visual Basic editor
- In Visual Basic Editor, click on the “Insert” menu
- Select “Module”
- 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
- Save your module
- Return to your Excel worksheet
- Paste the following code into the cell where you want to display the last modification time: =ModDate()
“The following features cannot be saved in macro-free workbooks: .VB Project. To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list. To continue saving as a macro-free workbook, Click Yes”. If you are getting this message while saving your module, you need to save your Excel file as Excel Macro-Enabled Workbook.
Note: The last modification time that will be displayed on your Excel sheet is the file-level modification time, and not the row-level modification time. In addition, when you make an edit, it doesn’t update automatically. You must close your file and reopen it to have the last update time.
Display Created Time and Last Modified Time in RowShareNow, let’s investigate another solution, an online collaboration tool which integrates with Excel to enhance your working efficiency. With RowShare’s “Creation Date” and “Last Write Date” column types, you can always be informed on when an entry was created and track when it was updated. All you need to do is to simply follow these steps:
- Create a table from a template or from a blank page.
- Add a column of type “Creation Date” and a column of type “Last Write Date”
As you can see, whenever a row is modified, the last write date of that row will be updated.
Tip: If you want to see the last modification time of the whole table, simply sort your “Last Write Date” column in descending order to see the last time your file was updated.That’s not everything! You can also get notified whenever a change is made. All you have to do is simply clicking on the “Bell” sign above your table on the top right. Whenever someone modifies any rows of the table that you are subscribed to, RowShare will send you a notification email.
Tip: If you already work using Excel, especially to analyze data, you can always import your work to RowShare to maximize your collaboration and use our Excel Sync feature.So, don’t just take my word for it, go ahead and give it a try yourself!