Overlapping Days Calculation Nightmare

There are 3 tables, 1) Slots, 2) Overlapping Dates and their Owners, 3) Owners Factors

I need to calculate (preferrably using a spill formula, but not mandatory) for each Slot (table 1) the number of business days in Overlapping Dates for each overlapping Owner (table 2) multiplied by the correspondent Factor (table 3).

Lastly, I'll calculate the business days multiplied by the number of Owners for each slot and will reduce the above figure... but this is the "easy" part of this calculation.

Image and Data Tables available below.

https://imgur.com/a/bZjdox9

Slots (table 1)

Overlapping Dates and Owners (table 2)

Owners Factors (table 3)

I tried SUMPRODUCT but I could not get the formula to calculate correctly the overlapping days as the formula below doesn't seem to work, let alone fit NETWORKINGDAYS in the middle of that. =SUMPRODUCT( (MAX( MIN( slot_end_date, overlapping_end_date ) - MAX( slot_start_date, overlapping_start_date+1 ), 0 ))

The idea of using MINIFS and MAXIFS came to my mind but apparently I'ld need to approach that via Lambda or even a number of Lambdas in a LET function. That was when I stopped worring that I would get stuck if excel limitations or with performance issues as the actual data is about 10 times bigger than the sample I share here.

So at the moment I have just put in what should be the total of business days for each slot so you can check them. As you say, multiplying by the factors should be fairly straightforward after that. The calculation is just a variation on the standard Min-Max formula.

=SUM(BYROW(Table2,LAMBDA(r,LET(end,MIN(INDEX(r,2),[@[Slot End Date]]),start,MAX(INDEX(r,1),[@[Slot Start Date]]),
IF(end>=start,NETWORKDAYS(start,end),0)))))