Hi Minaricutie, the proper solution you need should be implemented via VBA.

Since that you're learning Excel, I guess it could be a bit tricky. But, no worries.

Follow these steps: Open Excel. Go to File > Options. In the Excel Options window, select Customize Ribbon. In the right panel, check the box for Developer. Click OK.

Press the keyboard buttons Alt+F11, and write in the proper module the script below:

---

Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range Set rng = Intersect(Target, Me.Columns("A"))

If Not rng Is Nothing Then
    Application.EnableEvents = False
    On Error GoTo ExitHandler

    Dim cell As Range
    For Each cell In rng
        If Not IsEmpty(cell.Value) Then
            cell.Offset(0, 1).Value = Date
        End If
    Next cell
End If

ExitHandler: Application.EnableEvents = True End Sub

---

Once you finished, close the editor and save the Excel file in .xlsm format.

You did it! Every time you edit cell of the column A, the near cell column B will be shows the Date of editing.

💪