I stand corrected, I guess you can post attachments.

Scott, put this in D2 and fill down as necessary:

=IF(OR(C2<=B2,C2=""),IF(C2="",IF(B2TODAY(),"Not yet due","Overdue"),"On
Time"), "Received Late")


Mike F
"Scott" wrote in message
...