I cant seem to figure out the formula to determine if a vehicle is on time, past due or late.

Todays Date - Start Date - Est End Date - Completion Date - Status


Status is where I want to determine if the vehicle was

on time (est end date and completed date <=)

Past Due(veh exceeds est competed date and has no completion date)

Late (Veh is done but exceeded the est end date)

I used the today() for the todays date but its the LATE formula that keeps making me crazy.

I could use the help.

Thank you
Curt