How Can I Put a Last Updated in My Excel Workbook?

Create a User-Defined Function
1. Open the workbook and go to the sheet where you will be inserting the last updated date.
2. Click on 'Tools,' 'Macro' and 'Visual Basic Editor,' or just press the 'Alt' and 'F11' key at the same time.
3. Click on 'Insert' and select 'Module.' Your cursor will automatically be placed at the beginning of the open module.
4. Type (or copy and paste) the following user-defined function command into the module:Function SavedDate() As Date
Application.Volatile
SavedDate = ActiveWorkbook.BuiltinDocumentProperties.Item(12)
End Function
5. Click on 'File' and 'Close and Return to Microsoft Excel.'
Insert Last Updated Date
6. Go to the cell in your worksheet where you want to display the last updated date.
7. Type, or copy and paste, the following function:=SavedDate()
8. Press 'Enter.'
9. Right-click on your cell and select the 'Format Cells' menu.
10. Format your date by selecting the 'Date' category and choosing how you want your date to appear from the'Type' option. Click 'OK.'