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]

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?

[TABLE="class: cms_table, width: 196"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table, width: 196"]
<tbody>[TR]
[TD="class: cms_table_xl66, width: 74, align: center"]Service Due Date by the customer[/TD]
[TD="class: cms_table_xl66, width: 100, align: center"]Service Completion Date (Vendor)[/TD]
[TD="class: cms_table_xl66, width: 87, align: center"]IS the vendor Delayed?[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]1/26/18[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]1/30/18[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]1/26/18[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]1/20/18[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]2/20/18[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]1/0/00[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"][/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]2/16/18[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]2/16/18[/TD]
[/TR]
[TR]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]2/10/18[/TD]
[TD="class: cms_table_xl67, bgcolor: #DEEFF0"]1/0/00[/TD]
[/TR]
</tbody>[/TABLE]

 

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

[TABLE="width: 179"]
<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>[TR]
[TD="class: xl64, width: 74, bgcolor: #F2F2F2"]Service Due Date by the customer[/TD]
[TD="class: xl64, width: 100, bgcolor: #F2F2F2"]Service Completion Date (Vendor)[/TD]
[TD="class: xl68, width: 64, bgcolor: yellow"]IS the vendor Delayed?[/TD]
[/TR]
[TR]
[TD="class: xl66"]1/0/00[/TD]
[TD="class: xl66, bgcolor: #DEEFF0"]1/0/00[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"]1/0/00[/TD]
[TD="class: xl66, bgcolor: #DEEFF0"]1/0/00[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl66"]1/26/18[/TD]
[TD="class: xl66, bgcolor: #DEEFF0"]1/20/18[/TD]
[TD="class: xl65, bgcolor: transparent"]NO[/TD]
[/TR]
[TR]
[TD="class: xl66"]2/10/18[/TD]
[TD="class: xl66, bgcolor: #DEEFF0"]1/0/00[/TD]
[TD="class: xl65, bgcolor: transparent"]YES[/TD]
[/TR]
[TR]
[TD="class: xl66"]2/16/18[/TD]
[TD="class: xl66, bgcolor: #DEEFF0"]2/16/18[/TD]
[TD="class: xl65, bgcolor: transparent"]NO[/TD]
[/TR]
</tbody>[/TABLE]