Sharepoint Date Range Formula

Question

I am creating a vacation request site and must find the best way to update vacation rights for users when the date range includes a bank holiday. Currently, when users create a new request with [START TIME], for example, on August 29 and [END OF TIME] of September 4, the total number of holidays will be incorrect, as it will also include holidays in August. The column creates the total number of days that is subtracted from the vacation rights for users. I want the formula to check the date range and exclude any bank holidays from the total. Any help would be much appreciated. Damo

Answer 1

Unfortunately, the functionality of the SharePoint columns is not particularly advanced. However, take a look at this Pentalogic blog's Working Days, Weekdays, and Holidays in Calculated Columns , which may give you some suggestions.

If you find that you need to go down the user code route, look at the SO question. How do I set a default value in a SharePoint list box based on a value in another field? This shows how you can use JavaScript (in particular jQuery) to update a SharePoint field with a more advanced calculation.