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

Closed

Juwan Posts 1 Registration date Sunday January 8, 2017 Status Member Last seen January 8, 2017 - Jan 8, 2017 at 02:51 AM

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?

Date Value of a cell Determined by Specific Text in Another Cell
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
If cell contains specific text then return value in another cell vba ✓ - Excel Forum
Highlight cell if another cell contains text ✓ - Excel Forum
If cell contains text then return value in another cell ✓ - Excel Forum

Subscribe To Our Newsletter!