Forum

Notifications
Clear all

Check if a date in a named range falls between other dates in the same named range

2 Posts
2 Users
0 Reactions
189 Views
(@swallack202)
Posts: 77
Estimable Member
Topic starter
 

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

 
Posted : 13/01/2022 4:18 pm
(@mynda)
Posts: 4762
Member Admin
 

Hi Shawn,

Please see this tutorial on how to calculate if dates fall between a date range.

Mynda

 
Posted : 13/01/2022 8:02 pm
Share: