Hey all, I know there are tons of topics like this one but I cant seem to find one that works. I have a similar formula that someone provided me for another worksheet but I cant seem to modify it to fit my needs . So I'm looking to add a basic code to each sheet so that when the operator enters their name in for example: A1 then the current date is populated in B1. I need that date to stay fixed and not update whenever the workbook is opened again. I realized that happened when I attempted it with just a simple formula. Here's what I have:

Private Sub timestamp()

    If Range("A1").Value <> "" Then
              
        'Completion dates M, D, Y'
        Range("B1").Value = Date
        
    End If
End Sub
Maybe im oversimplifying it... Any thoughts?