If you are looking for some special tricks to insert the last saved date in Excel, you’ve come to the right place. In Microsoft Excel, there are numerous ways to insert the last saved date. In this article, we’ll discuss two methods to insert the last saved date. Let’s follow the complete guide to learn all of this.
Find the Last Saved Date in Excel
This is the fastest way to find out when an Excel file was last saved. Firstly, go to the File tab, then select Info.
As soon as the Info window appears, you’ll see the last modified date on the right side.
Insert Last Saved Date in Excel: 4 Examples with Excel VBA
We will use three effective and tricky methods to insert the last saved date in Excel in the following section. This section provides extensive details on three methods. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.
1. Using BuiltinDocumentProperties
By using a simple code, you will be able to insert the last saved date quickly. You have to follow the following steps.
📌 Steps:
- Firstly, press ALT+F11 or you have to go to the tab Developer, select Visual Basic to open Visual Basic Editor, and click Insert. Select Module.
- Next, you have to type the following code:
Sub Last_Saved_Dates_1()
Range("C4").Value = Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), "short date")
End Sub
- After that, close the Visual Basic window, and press ALT+F8.
- When the Macro dialogue box opens, select Last_saved_Dates_1 in the Macro name. Click on Run.
Finally, you will be able to insert the last saved date in Excel as follows:
Read More: How to Insert Static Date in Excel
2. FileDateTime Statement to Insert Last Saved Date
By using a simple code, you will be able to insert the last saved date quickly. You have to follow the following steps.
📌 Steps:
- Firstly, press ALT+F11 or you have to go to the tab Developer, select Visual Basic to open Visual Basic Editor, and click Insert. Select Module.
- Next, you have to type the following code:
Function LastSaveDate2()
LastSaveDate2 = FileDateTime(ActiveWorkbook.FullName)
End Function
- Afterward, you must return to the spreadsheet, and type the following function in cell C4.
=LastSaveDate2()
Finally, you will be able to insert the last saved date in Excel as follows:
Read More: How to Insert Date in Footer in Excel
3. Custom Formatting with Excel VBA
By using a simple code, you will be able to insert the last saved date quickly. You have to follow the following steps.
📌 Steps:
- Firstly, press ALT+F11 or you have to go to the tab Developer, select Visual Basic to open Visual Basic Editor, and click Insert. Select Module.
- Next, you have to type the following code:
Function last_saved_date()
last_saved_date = Format(FileDateTime(ThisWorkbook.FullName), "m/d/yy h:n ampm")
End Function
- Afterward, you must return to the spreadsheet, and type the Function in cell C4.
=Last_saved_date()
Finally, you will be able to insert the last saved date in Excel as follows:
Read More: How to Remove Time from Date in Excel
4. VBA Now Function to Insert Last Saved Date
By using a simple code, you will be able to insert the last saved dates quickly. You have to follow the following steps.
📌 Steps:
- Firstly, press ALT+F11 or you have to go to the tab Developer, select Visual Basic to open Visual Basic Editor, and click Insert. Select Module.
- Next, you have to type the following code:
Sub last_saved_date_4()
Range("C4").Value = Now
End Sub
- After that, close the Visual Basic window, and press ALT+F8.
- When the Macro dialogue box opens, select last_saved_date_4 in the Macro name. Click on Run.
Finally, you will be able to get the output as follows:
Read More: Formula for Weekly Dates in Excel
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
That’s the end of today’s session. I strongly believe that from now you may insert the last saved date in Excel. If you have any queries or recommendations, please share them in the comments section below.
Keep learning new methods and keep growing!