Replicate Excel function Network days in SQL without creating table or view

[james10]

Hello,
Following on from above is it possible to do similar as above exclude bank holidays but due to permissions on the server I am unable to create a table currently.