It seems to me your formula could be reduced to something like:
Code:
=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(D2="YES",IF(AND(B2>=$H$1,E2>=B2),"Proactive",""),"")),""))))
Note where I have inserted "". Those indicate missing arguments from your calculations. By comparison, the missing arguments in your existing formula are as indicated by "" in:
Code:
=IF(F2="No","Delivery date needed",IF(F2="Yes",IF(C2<>"","Services",IF(D2="NO",IF(B2>$H$1,"Schedule not due yet",IF(F2="Yes",IF(C2="",IF(D2="NO",IF(B2<H$1,IF(E2="","Missing",IF(F2="Yes",IF(C2="",IF(D2="Yes",IF(B2>=$H$1,IF(E2>=B2,"Proactive",""),""),""),""),"")),""),""),""),"")),"")),""))