Nested if
 

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.

Nested if
 

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.

Nested if
 

Hi

With Due Date in A1 and Submitted in B2

=IF(AND(B2="",TODAY()-A2<=0),"Waiting",
IF(AND(B2="",TODAY()-A20),"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
--
Regards

Roger Govier


"mwavra" wrote in message
...
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.

Nested if
 

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

"JE McGimpsey" wrote:

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.

Nested if
 

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

"Roger Govier" wrote:

Hi

With Due Date in A1 and Submitted in B2

=IF(AND(B2="",TODAY()-A2<=0),"Waiting",
IF(AND(B2="",TODAY()-A20),"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
--
Regards

Roger Govier


"mwavra" wrote in message
...
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.