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.

[TABLE="width: 196"]
[TR]
[TD="class: xl66, width: 74, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: center"]Service Due Date by the customer[/TD]
[TD="class: xl66, width: 100, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: center"]Service Completion Date (Vendor)[/TD]
[TD="class: xl66, width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F2F2F2]#F2F2F2[/URL] , align: center"] IS the vendor Delayed?[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #DEEFF0"]1/26/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"]1/30/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #DEEFF0"]1/26/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"]1/20/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #DEEFF0"]2/20/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"]1/0/00[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #DEEFF0"]2/16/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"]2/16/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #DEEFF0"]2/10/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"]2/14/18[/TD]
[TD="class: xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[/TABLE]

 

[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.