Find Text & Convert to Date Values

Hi

Creating a project tracker with a 3-Week Look Ahead

As you will see in attached example, we are tracking what we call CPs and its Turn Over (TO) dates

Currently we are tracking PLANNED Turn Over dates but not ACTUAL dates


Need assistance to modify

'=IF(D20="","",IF(D20="X","X",DATEVALUE(RIGHT(D20,LEN(D20)-2))))


See example
-- This is currently showing PLANNED CPs per day or week
-- Want to show both PLANNED & TURNED OVER (TO) dates

For example - With Date, TO 9/8, it will show "TO 9/8" in its applicable cell