Check if a date in a named range falls between other dates in the same named range|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I have a table (tblProjectDates) with project START DATE and END DATE columns (columns A and B, respectively). The same table is also a named range (rngProjectDates). Dates are always in MM/DD/YYYY format.

I'm looking for a formula in column C to determine whether any value in Column A (start date) or Column B (end date) overlaps with any of the periods between these dates.

For example:

[ROW] | [START DATE] | [END DATE] [FORMULA??]

[1] 01/01/2022 | 01/15/2021 | END DATE falls between dates in Row [5]

[2] 02/01/2022 | 02/28/2021 | START DATE falls between dates in Row [5]

[3] 03/01/2022 | 03/30/2021 | END DATE falls between dates in Row [4]

[4] 03/15/2022 | 04/30/2021 | START DATE falls between dates in Row [3] and END DATE falls between dates in Row [5]

[5] 01/10/2022 | 05/15/2021 | START DATE falls between dates in Row [1]

Dates change from time to time and the table is expandable (i.e., more projects will be added over time).

The outcome I seek is the identification of any overlap between periods.

Thanks