B2=$H$1,"Due today"
B2<$H$1,E2<>0, E2<>0 is "Missing" when there a date in E2 if it is greater the $H$1,"Current", if less than "Expired"

B2>=$H$1,E2<$H$1, I need to think on this.
D2="" D will always have a yes or no, system report.(I should stated before)