Automatic Dates?

[SLOTurtle]

Hello,

Is there a way to have a cell with the date that automatically updates itself every time the excel worksheet is updated/worked on and saved??

Thanks,

SLOTurtle

 

[kpark91]

Hi, yes there is a way and it is through VBA.

Right click on the tab of your worksheet and copy + paste these code onto it.
If your cell is A1 then use this code for updating A1 value with current Date when any cell is changed in your worksheet.

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = False
    Range("A1").Value = Date
    Application.EnableEvents = True
End Sub

Put this in ThisWorkbook module which can be found in the left-top pane of your Visual Basic Editor

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Application.EnableEvents = False
    Worksheets("Sheet1").Range("A1").Value = Date
    Application.EnableEvents = True
End Sub

Obviously, if you want to change the cell to be populated.
Change A1 to your cell reference
and change Sheet1 to the name of your sheet in which your cell is updated.