However, you can create a Macro function that will return this value.įirst, open the Visual Basic editor by pressing Alt+ F11. Question: In Microsoft Excel, how can I autoupdate a date on an Excel worksheet to the Last Modified Date?Īnswer: There is no built-in function in Excel that will return the last modified date of an Excel Workbook (ie: Excel file). 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). MS Excel: Function that returns Last Modified date for Workbook
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |