Paul,
I think I got all of the conditions catered for. Check this formula
=IF(B2+C2=0,"Delivery date needed",IF(C2>0,"Services",IF(AND(D2="NO",B2>$H$1) ,"Schedule not due yet",IF(D2="NO",IF(AND(B2<H$1,E2=0),"Missing",IF(D 2="YES",IF(AND(B2>=$H$1,E2>=$H$1),"Proactive",IF(D 2="YES",IF(AND(B2<$H$1,E2>=$H$1),"Current",IF(D2=" YES",IF(AND(B2<$H$1,E2<$H$1),"Expired")))))))))))

When D2="YES", it returns "FALSE" Any suggestions?