How to Insert Last Saved Date in Excel (4 Examples)

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.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


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

Find Last Saved Date in Excel

As soon as the Info window appears, you’ll see the last modified date on the right side.


4 Examples with Excel VBA to Insert Last Saved Date in Excel

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.

Embedding VBA Code to Insert Last Saved Date in Excel

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

Embedding VBA Code to Insert Last Saved Date in Excel

Finally, you will be able to insert the last saved date in Excel as follows:

Read More: How to Insert Date in Excel Formula (8 Ways)


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.

Embedding VBA Code to Insert Last Saved Date in Excel

  • 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:

Embedding VBA Code to Insert Last Saved Date in Excel

Read More: How to Insert Day and Date in Excel (3 Ways)


Similar Readings


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.

Embedding VBA Code to Insert Last Saved Date in Excel

  • 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 Insert Date in Excel (7 Simple Methods)


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.

Embedding VBA Code to Insert Last Saved Date in Excel

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

Embedding VBA Code to Insert Last Saved Date in Excel

Finally, you will be able to get the output as follows:

Embedding VBA Code to Insert Last Saved Date in Excel

Read More: Excel Macro: Insert Date and Time in a Cell (4 Examples)


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.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo