Return "yes" "no" awhile comparing dates in different columns

[AS12Excel]

Hello, I need help on finding the best way to analyze when a vendor is delayed on providing services. I have worked on this for the past 2 days with AND and IF formulas but cannot get anywhere. Here is an example. I have couple items delayed and 1 in progress (3rd line). Thanks in advance! My table has about 500 lines and this is just a sample.

Service Due Date by the customer	Service Completion Date (Vendor)	IS the vendor Delayed?
1/26/18	1/30/18
1/26/18	1/20/18
2/20/18	1/0/00
2/16/18	2/16/18
2/10/18	2/14/18

 

[Joe4]

Welcome to the Board!

If your first row of data is in cells A2 and B2, is this what you are looking for (in column C2):

=IF(B2>A2,"Yes","No")

 

[AS12Excel]

Welcome to the Board!

If your first row of data is in cells A2 and B2, is this what you are looking for (in column C2):

=IF(B2>A2,"Yes","No")

Joe, thanks for your fast reply. I forgot to mention the following condition:

If column A has a date 2/10/18 and column B 1/0/00(means VALUE 0) which means the vendor still pending services delivery. In this case, i need my column C to show "YES" AS delayed.
Your first thought is what i have but it's not totally accurate. Any idea of what condition is missing to obtain "YES" or True on column vendor delayed?

<tbody>
</tbody>

Service Due Date by the customer	Service Completion Date (Vendor)	IS the vendor Delayed?
1/26/18	1/30/18
1/26/18	1/20/18
2/20/18	1/0/00
2/16/18	2/16/18
2/10/18	1/0/00

<tbody>
</tbody>

 

[Joe4]

Try:

=IF(OR(B2>A2,B2=0),"Yes","No")

 

[AS12Excel]

Almost worked! For all dates under today’s date then tomorrow’s date and so forth the condition also assigns as vendor’s delay. Anyway I can add NOT B2=0 in the formula?

 

[Joe4]

For all dates under today’s date then tomorrow’s date and so forth the condition also assigns as vendor’s delay.

Not sure what I understand what you are trying to say here.

Anyway I can add NOT B2=0 in the formula?

That would look like:
B2<>0

 

[Joe4]

I think I might see where you are going with this.
Does this do what you want?

<today()),and(b2>=IF(OR(AND(B2=0,A2 < TODAY()),AND(B2>A2,B2<>0)),"Yes","No")

</today()),and(b2>

 

[AS12Excel]

Hey Joe, I have to confess the logic sometimes can be way beyond to my understanding. That portion was resolved than I have 302 rows with customer and vendor date (1/0/00) which brings me as “YES” vendor’s delayed.
I have not much experience on nesting more than 2 functions and that’s the reason of my frustration.
My apologies for all the concerns.

 

[Joe4]

So did my last suggestion work for you?

 

[AS12Excel]

<today()),and(b2>=IF(OR(AND(B2=0,A2 < TODAY()),AND(B2>A2,B2<>0)),"Yes","No")

</today()),and(b2>[/QUOTE]


How can I add in the above formula, when column A and B=0 or 1/0/00, column C replies "NO"? This is the only codition that is now missing. Everything else works perfectly.

Service Due Date by the customer	Service Completion Date (Vendor)	IS the vendor Delayed?
1/0/00	1/0/00
1/0/00	1/0/00
1/26/18	1/20/18	NO
2/10/18	1/0/00	YES
2/16/18	2/16/18	NO

<colgroup><col width="74" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2645;"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3555;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2275;"> <tbody> </tbody>