similar concept i did for a client used the following formula...
IF({status}="PLD","1. Trending Early",IF({actualCompletionDate} = "",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, {projectedCompletionDate})<0,"1. Trending Early",IF(WEEKDAYDIFF({DE:Final Approved Deliverable Due Date}, ...