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.

Please Login or Register  to view this content.

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