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?
Date Value of a cell Determined by Specific Text in Another Cell