=IF(0<D2<=C2, "on time",IF(AND(B2>C2, D2=""), "past Due", IF(D2>C2, "late", "on time")))
sorry doesn't work
I get on time and late but it should have some PAST dues since the vehicle is not done yet.
The vehicles that do not have a completed date should be shown as past due. No value is in that cell and that may be what the hang up is.
This one is killing me.
Curt
Bookmarks