How To Exclude Bank Holidays From Network Days

[bloodmilksky]

Hi Guys,

I was just wondering if anyone knows how to exclude UK Bank Holidays from Networkdays? ideally using a formula or select case?

Many thanks

Jamie

 

[Scott T]

use networkdays.intl list the holidays and refer to the range in the holiday augment.

=NETWORKDAYS.INTL(start date,end date,[weekend],[holidays])