Predefined Calculation: Seeded SLA Date
Summary
This formula will return a date that is a certain number of working days in the future taking into account weekends and public holidays from the start date.
Inputs
This formula requires 5 inputs to be passed through to it:
Number of days
How many working days after the current date the result should be.
Date format
The date format used for the result of the calculation.
Region
Which region to consider bank holidays for. Currently, only regions in the UK are supported.
Start date
The date to calculate the SLA from
Start date format
The format of the start date
Return values
Value | Description |
---|---|
The SLA date | Calculated by adding the specified number of working days from the start date. |
Formula Logic
The public holidays for the selected Region are obtained.
The SLA date is set to the start date.
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.