How do I get Excel to insert the saved date?

Question

When I save an Excel document, I want it to insert the saved date and time into the spreadsheet so that, when I open it later, I'll be able to see the original saved date (not today's date). Is there a way to do that? What's the formula?

Answer 1

there is a before-save macro you can use to do that. Saving your document will trigger this macro and then do whatever you want it to do :

This macro is a ThisWorkBoook Macro :
-1- To access the Visual Basic Editor, press ALT+F11
-2- Locate "thisworkbook" and double-click on it
-3- on the right hand side locate the drop down menus where it says (general) and right next to it (Declarations)
-4- copy and paste the code below

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Range("A1") = "last time saved " & Now
End Sub

Range("A1") means that the macro will insert the date and time in the cell A1 of the active sheet, each time you save the document

if you want to choose another cell and / or sheet, or make sure that the saved date will be put in the same cell of the same sheet, regarless the sheet you are working on at the time of saving your document you can change Range("A1") to something like
Worksheets("Sheet1") . Range("A1") = "Last time saved : " & Now

Answer 2

for date and time:
=NOW()

for just the date:
=TODAY()

In order to view previously saved dates, you'll have to manually enter that information each time you save it. To my knowledge there is not a historical formula.

Answer 3

Type the date that you created the spreadsheet in manually; don't use the auto-insert option.

Answer 4

bypass into ideas and convey interior the fields icon onto your speedy get entry to toolbar, then once you click on that icon, you've all fields and larger, that you used to have on the header and footer toolbar less than Insert button.