Date Value of a cell Determined by Specific Text in Another Cell [Closed]

Report
Posts
1
Registration date
Sunday January 8, 2017
Status
Member
Last seen
January 8, 2017
-
Hello,

This is a two part question:
1) I have three columns (A, B & C). Column A is populated with specific text such as "interviewed" or "set apart". I want column B to populate with the date of the day column A reads "interviewed", or the same for column C if A reads "set apart", AND I don't want that date to change.

2) The next part is a bit harder. As time goes on, the status of Column A could change from "interviewed" to "set apart". If this happens, I want Column C to populate with the date "set apart" is entered, but keep the previous date in Column B from "interviewed". Is this possible?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!