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]

How about this minor edit:

<today()),and(b2>=IF(OR(AND(B2=0,A2 < TODAY()[COLOR=#ff0000],A2<>0[/COLOR]),AND(B2>A2,B2<>0)),"Yes","No")</today()),and(b2>

 

[AS12Excel]

How about this minor edit:

<today()),and(b2>=IF(OR(AND(B2=0,A2 < TODAY()[COLOR=#ff0000],A2<>0[/COLOR]),AND(B2>A2,B2<>0)),"Yes","No")</today()),and(b2>

BIG THANK YOU! I actually learned the logic and will apply in the future in similar cases! I'm looking for Advanced Excel lessons as well. I'll check the website offers. Have a great day!

 

[Joe4]

You are welcome!
Glad I was able to help.