Displaying Last Modification Time in Excel

Ever wonder how to insert date in Excel, more particularly to insert last modification date in your Excel cell? For your work in Excel, last modified date will make tracking easier.

Let’s say you maintain an employee directory, people get hired, move to different office branch, etc. You use Excel to centralize each employee’s information such as hiring date, position, office branch, and more.

You have several prints of the file, and if someone (could be your colleague, team member, or employee concerned) modifies it online, but your Employee Directory file doesn’t show last modification time, it will be difficult for you to know which version of the prints is the most updated. Having your file showing you the last time it was modified will make your work easier.

In this article, we will firstly see how to display creation time and last modification time in Excel. Then, we will see how RowShare, an alternative that integrates with Excel, can respond to this need.

Excel’s Last Modified Date Function

If 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

Paste the following code into the cell where you want to display the last modification time:

=ModDate()

In this example, the code is pasted in cell A2.

“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.

Display Created Time and Last Modified Time in RowShare

Now, 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.