Calculate a working week date range inside a broader day range considering different calendar reason

Hi Anonymous ,

The result is actually not a table but column "travel dates authorized" highlighted in yellow which is a column which I would like to add to the "actual travel" table. 

The idea is that I need to check if an entry was raised for the "person ID" in the "travel requested" table covering the full range of working days from the "actual travel" start to end. If all weekdays are covered than the result is "yes".

The problem is that the "travel requested" start or end dates might be on a weekend if the input was not done correctly so it is not sufficient to check if the closest weekday to the "actual travel" is included in the "travel requested range".

The other problem is that the working week is different for the entries marked as Middle East as it goes from Sunday to Thursday and not Monday to Friday. 

Hope this clarifies.

Thanks for your interest in helping me solve this issue.

Mike