Write date in cell and fix it

Occasional Visitor

I have excel sheet , where i have lets say column B AND C , in column B12 if i insert name of product i want to write in column c12 the date i inserted the name of product , i have used the if considtion and its working fine (lets say today is : 30/01/2019) , but if i will insert tomorow a new product name all the cells will ge the date of tomorow..... :(


can you please help ? 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
203 Replies