One way:

Assume date submitted in column A, due date in column B.

C1: =IF(A1="",IF(B1=TODAY(),"","Late"),IF(A1<=B1,"On Time","Late"))

In article ,
mwavra wrote:

I have been trying to figure this out for quite a while and can't get
anything to work. Here's what I have.

A list of due date, date submitted. I want to show in another column, when
something is late or on time. If not submitted yet, and due date is today or
beyond, the late/on time indicator can be blank. If blank and due date has
passed, show late. If submitted by or before due date, it's on time.

Hope someone can help me construct the correct formula.

Thanks.