Need date field to update when data entered, but retain that date

In the attached, I want to be able to enter a quantity in the C Column, and have excel automatically stamp the date in the next column, the problem is, when I come back the next day and add a new quantity, excel updates all dates and not just the current date.

What I am looking for, is to have a date-stamp where we can keep track of when something was added to column C.

Hope it makes sense, and thanks in advance!
SSS.xlsm
Eli

Try this and let me know if it works. You can change the range if needed.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Request_Quantity As Range
   
    Set Request_Quantity = Range("C6:C100")
    
    If Not Application.Intersect(Request_Quantity, Range(Target.Address)) _
           Is Nothing Then
    ActiveCell.Offset(-1, 1).Select
    ActiveCell.FormulaR1C1 = "=IF(RC[-1]>0,NOW())"
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    End If
End Sub

That worked perfectly Vidya!!! Thank you VERY much!!!