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 |