Spreadsheet: 860089d1708322004-formula-to-check-overlapping-dates-by-another-column-formula-to-check-overlapping-dates-by-another-column-jt-
Sheet: Sheet1

ITEM | QUANTITY | INSTALL DATE | PICK UP DATE | PACKAGE | NO. WEEKS | HD | JT |  |  | Workings: | First Occurance Dates |  | Availaility | Combined Formula | Adj First Occurance Dates |  | Availaility
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-08 00:00:00 | 2023-10-03 00:00:00 | Essential | 8 |  |  | <-- the first occurance of this item, so should show "Available"
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-21 00:00:00 | 2023-10-16 00:00:00 | Essential | 8 |  |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-22 00:00:00 | 2023-10-03 00:00:00 | Essential | 6 |  |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2023-08-28 00:00:00 | 2023-10-09 00:00:00 | Essential | 6 |  |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.0 SEAT UPHOLSTERED SOFA | 1 | 2024-01-09 00:00:00 | 2024-02-13 00:00:00 | DESIGNER | 5 |  |  | <-- correct as the item is not available until after 3/10 (line 2)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-17 00:00:00 | 2023-09-11 00:00:00 | Essential | 8 |  |  | <-- the first occurance of this item, so should show "Available"
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-08-29 00:00:00 | Essential | 6 |  |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-07-18 00:00:00 | 2023-09-12 00:00:00 | Essential | 8 |  |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-11 00:00:00 | 2023-10-06 00:00:00 | Essential | 8 |  |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-11 00:00:00 | 2023-09-28 00:00:00 | Essential | 6 |  |  | <-- should show as "Available" because the date is after 11/9
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-01 00:00:00 | 2023-10-17 00:00:00 | Essential | 8 |  |  | <-- correct as the item is not available until after 11/9 (line 7)
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-08-29 00:00:00 | 2023-10-24 00:00:00 | Essential | 8
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-30 00:00:00 | 2023-11-06 00:00:00 | Essential | 6
01_2.5 SEAT UPHOLSTERED SOFA | 1 | 2023-09-26 00:00:00 | 2023-11-12 00:00:00 | Essential | 6 |  |  | <-- what happens when the item is avail, so now it is taken (row above) and this row should be Check
[NAME] to check overlapping dates by another column
[NAME] to check overlapping dates by another column - Reply to Topic (excelforum.com)
 |  |  |  | True | True | True | False
 |  |  |  | False | True | True | False
 |  |  |  | False | True | True | False
 |  |  |  | False | True | True | False
 |  |  |  | True | True | False | False
 |  |  |  | True | False | True | True
 |  |  |  | False | False | True | True
 |  |  |  | False | False | True | True
 |  |  |  | False | True | True | True
 |  |  |  | True | False | True | True
 |  |  |  | False | True | True | True
 |  |  |  | False | True | True | True
 |  |  |  | False | True | True | True