I am trying to create a table for my employees to track orders they are working. I want to make it as simple as possible for them, so I created a drop-down menu in column A for them to choose their name, a drop-down in column B for them to select the type of order, and I want column C to auto fill the date they made the entry. I used formula =IF([A2]<>[A2],””,TODAY()) and it worked for populating the date yesterday, but today when I opened the sheet, the dates from yesterday automatically changed to today. Is there a formula that will ensure the old entry dates remain and the new entries reflect the day they were entered moving forward?

​I am trying to create a table for my employees to track orders they are working. I want to make it as simple as possible for them, so I created a drop-down menu in column A for them to choose their name, a drop-down in column B for them to select the type of order, and I want column C to auto fill the date they made the entry. I used formula =IF([A2]<>[A2],””,TODAY()) and it worked for populating the date yesterday, but today when I opened the sheet, the dates from yesterday automatically changed to today. Is there a formula that will ensure the old entry dates remain and the new entries reflect the day they were entered moving forward?  Read More

​