Nested if

[Guest]

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.

 

[JE McGimpsey]

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"))

 

[Roger Govier]

Hi

With Due Date in A1 and Submitted in B2

=IF(AND(B2="",TODAY()-A2<=0),"Waiting",
IF(AND(B2="",TODAY()-A2>0),"Late",
IF(AND(B2<>"",A2-B2<0),"Late","on time")))

Change "Waiting to "" if you just want to show an empty cell where it is
neither Late nor On time

 

[Guest]

Thank you very much!!!! I had one close, but this, of course, is perfect.

 

[Guest]

Thank you so much. I especially liked being able to show "waiting" or
"pending." Thanks again.