Skip to main content

SLA Date

  • What is it? This formula will return a date that is a certain number of working days in the future taking into account weekends and public holidays.

Inputs​

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.

  • 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.

Return values​

ValueDescription
The SLA dateCalculated by adding the specified number of working days to the current date.

Formula Logic​

  1. The public holidays for the selected Region are obtained.

  2. The SLA date is set to the next working day.

  3. The SLA date is moved forward by the amount of weekdays in the Number of days input.

  4. For every public holiday between the next working day and the SLA date, an additional weekday is added.

  5. The resulting SLA date is returned as the result of the calculation, formatted according to the Date format input.

  6. The result of the calculation is cached against the current date and provided inputs.