I have a lovely formula whichI got here on the forum that allows me to calculate the number of business days for my holiday recording system in Salesforce - but now I have an issue of Bank Holidays - how can I specify Bank Holidays so that these are not counted as business days ?
4 件の回答
Hi Olivia,
This might be little difficult to get this in a formula field, you may need an apex trigger for this.
the only way with the formulas is hardcoding the bank holidays into the formula and see if the bank holiday falls between your Leave Start and Finish Date, this is achievable as long as you have users in one single country.
If you have users in different countries and each country may have different bank holidays the formula will exceed the maximum compilation size.
