Time Stamp

[Newbienew]

I am looking to make a timestamp when an entry is made. I am using columns A and B. I used one formula I found online however each time I put new entry in the times would shift. I dont need the times but just the dates. thank you in advance.

 

[mrshl9898]

Add this to the Worksheet module.

*It'll date stamp column C on the row a change is made to A or B. Wasn't 100% sure of the requirement there.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range

Set KeyCells = Range("A:B")

If Not Application.Intersect(KeyCells, Range(Target.Address)) _
           Is Nothing Then

Cells(Target.Row, 3) = Format(Now(), "DD/MM/YYYY")
End If

End Sub

 

[Newbienew]

Thank you so much. Is it possible to also get a formula as well

 

[mrshl9898]

No, =TODAY() or =NOW() will keep refreshing, i'm guessing that was your original problem.

 

[Newbienew]

Yes that was my issues. Just trying to freeze that date