Update date when a certain cell is changed

Sam_Chig

Right-click the sheet tab.
Select 'View Code' from the context menu.
Copy the code listed below into the code window.
Close the Visual Basic Editor.
Save the workbook as a macro-enabled workbook (*.xlsm).
Make sure that you allow macros when you open it.
Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim tbl As ListObject
    Set tbl = Me.ListObjects(1) ' or Me.ListObjects("Table1") or similar
    If Not Intersect(tbl.ListColumns("Attempt #").DataBodyRange, Target) Is Nothing Then
        Application.ScreenUpdating = False
        Application.EnableEvents = False
        Intersect(tbl.ListColumns("Attempt #").DataBodyRange, Target).Offset(0, -2).Value = Date
        Application.EnableEvents = True
        Application.ScreenUpdating = True
    End If
End Sub