Find Last Date & Time Excel File Was Modified [Tutorial]
13Find Last Date & Time Excel File Was Modified [Tutorial]
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.
Issues addressed in this tutorial:
excel modified by another user
excel add modified date
excel last modified date and time worksheet
This Excel tutorial explains how to write a macro that returns the last modified date for the Wookbook and displays that date value in a cell (with screenshots and step-by-step instructions).
This tutorial will apply for Microsoft Excel 2021, 2019, 2013, and 2010 for both Windows (such as Dell, HP, Lenovo, Samsung, Toshiba, Acer, Asus) and macOS (MacBook Air, MacBook Pro, MacBook Mini) devices.