title: Sharepoint date range formula
body: <p>I am creating a holiday request site and need to find the best way to update users holiday entitlements when the date range includes a bank holiday.   Currently when users create a new request with a [START TIME] of say 29th Aug and [End TIME] of 4 September the total number of holidays will be incorrect as it will also include the Aug bank holiday. The column creates a total number of days to be deducted from the users holiday entitlements. I want a formula to check the date range and exclude any bank holidays from the total.  Any help will be much appreciated.  Damo</p>