Spreadsheet: 806286d1669214416-if-statement-using-dates-and-times-example-1
Sheet: Sheet3

 | [NAME] | Customer Name | Arrival Date/Time | Final Process Date | Counted? | Comments |  | Dates | Days | Holidays
 | Tracker ID 1 | ABC Customer | 2022-11-17 09:59:00 | 2022-11-18 23:59:00 | NO | Arrived on a Thursday before 10:00am and didn't process until the following weekday. Counted = NO |  | 2022-11-14 00:00:00 |  | 2022-11-24 00:00:00
 | Tracker ID 1 | ABC Customer | 2022-11-17 10:00:00 | 2022-11-18 23:59:00 | YES | Arrived on a Thursday at or after 10:00am and didn't process until the following weekday. Counted = YES |  | 2022-11-15 00:00:00 |  | 2022-11-25 00:00:00
 | Tracker ID 2 | ABC Customer | 2022-11-18 09:59:00 | 2022-11-21 23:59:00 | NO | Arrived on a Friday before 10:00am and didn't process until the following weekday. Counted = NO |  | 2022-11-16 00:00:00
 | Tracker ID 2 | ABC Customer | 2022-11-18 10:00:00 | 2022-11-21 23:59:00 | YES | Arrived on a Friday at or after 10:00am and didn't process until the following weekday. Counted = YES |  | 2022-11-17 00:00:00
 | Tracker ID 3 | ABC Customer | 2022-11-23 09:59:00 | 2022-11-28 23:59:00 | NO | Arrived on a Wednesday before 10:00am and didn't process until the following available weekday. Counted = NO |  | 2022-11-18 00:00:00
 | Tracker ID 3 | ABC Customer | 2022-11-23 10:00:00 | 2022-11-28 23:59:00 | YES | Arrived on a Wednesday at or after 10:00am and didn't process until the following available weekday. Counted = YES |  | 2022-11-19 00:00:00
 |  |  |  |  |  |  |  | 2022-11-20 00:00:00
 |  |  |  |  |  |  |  | 2022-11-21 00:00:00
 |  |  |  |  |  |  |  | 2022-11-22 00:00:00
 | Desired Logic Explanation |  |  |  |  |  |  | 2022-11-23 00:00:00
 | When a shipment arrives before 10:00am on any given weekday, the expectation is that it get processed that same day. If not, it should produce a "NO" in column F |  |  |  |  |  |  | 2022-11-24 00:00:00
 | When a shipment arrives at or after 10:00am on any given weekday, the expectation is that it get processed the following available weekday. If so, it should produce a "YES" in column F |  |  |  |  |  |  | 2022-11-25 00:00:00
 |  |  |  |  |  |  |  | 2022-11-26 00:00:00
 | The formula has to be able to account for weekends since we don't process anything on Saturdays or Sundays. So, if a shipment were to arrive on a Friday before 10:00am and it gets processed the |  |  |  |  |  |  | 2022-11-27 00:00:00
 | following Monday, this would be counted as "NO". If the same shipment were to arrive on a Friday at or after 10:00am and it gets processed the following Monday, this would be counted as "YES" |  |  |  |  |  |  | 2022-11-28 00:00:00
 |  |  |  |  |  |  |  | 2022-11-29 00:00:00
 | We also don't process anything on holidays. Using Thanksgiving as an example, if a shipment were to arrive before 10:00am on Wednesday and it gets processed on the following Monday, this would be |  |  |  |  |  |  | 2022-11-30 00:00:00
 | counted as "NO". If the shipment arrives at or after 10:00am on Wednesday and gets processed on Monday, it would counted as "YES"
 | I think I need some helper columns to identify the days of the week for each date and the dates that we consider holidays but beyond that, I'm not sure how to write this IF statement.