OTBI: Find the number of Working/Business Days between two dates and exclude Public Holidays

Summary

OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holidays

Content

Hi All, 

My client is an Oracle Fusion SaaS customer and are currently developing a number of reports in OTBI. 

They have a requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holidays. 

I have two logical OBIEE formulas that exclude Weekends, both of which seem to be working fine, and I have pasted them below. The big issue we've got is excluding