Determine if a date range falls with another date range

[mrichard]

Hi all,

I am trying to write a formula to determine if date range falls within another date range.

Example:

Start Date, End Date
8/12/24, 8/11/25

And I have another date range of:
Start Date, End Date
8/1/24, 8/31/24

I have the formula working for determining if a single date that falls within a date range but not two date ranges.
Any help would be greatly appreciated.

Thanks
MRR

 

[hagia_sofia]

Do you mean that the second range belongs to the first one completely or at least partially?

 

[mrichard]

Hmmmm how do I explain this.
I have trying determine if the first date range of 8/12/24 - 8/11/25 falls within second date range of 8/1/24 - 8/31/24 fully or partially.

 

[mrichard]

I am trying to calculate the number of workdays between 8/1/24 - 8/31/24 in the range of 8/12/24 - 8/11/25.
I have the workdays part of the formula working