hmm, I have to add something, the above works obviously because the days are sequential (N & N+1).
However what if you have a holiday that takes 10 days, then the above formula would leave out 8 days, it would only take into account the start & the end date.
Well to solve that I see two options. The easiest one is to create an extra column in the first table that contains all the holidays and you take this list. It looks like this:
Imagine you have huge tables and you do not want to store all the data (because factually you do not need it), you only need to calculate with it. In that case we virtualise the calculation.
I split the process in a few steps:
step 1: 1 look for corresponding holidays
Step 2, I take per holiday the dates (formatted as numbers):
and then the step 3 is to use this list of dates in the formula.
This one fails.
the list of dates is not excluded and I do not know why.
An alternative to this base formula
NetWorkingDays is to exclude weekends as day number 1 and 7 and excluding the holidays like below:
This one works.