Predefined Calculation: SLA Date
This formula will return a date that is a certain number of working days in the future taking into account weekends and public holidays.
This formula requires 3 inputs to be passed through to it:
Number of days
How many working days after the current date the result should be.
The date format used for the result of the calculation.
Which region to consider bank holidays for. Currently, only regions in the UK are supported.
|The SLA date||Calculated by adding the specified number of working days to the current date.|
The public holidays for the selected Region are obtained.
The SLA date is set to the next working day.
The SLA date is moved forward by the amount of weekdays in the Number of days input.
For every public holiday between the next working day and the SLA date, an additional weekday is added.
The resulting SLA date is returned as the result of the calculation, formatted according to the Date format input.
The result of the calculation is cached against the current date and provided inputs.