Service Level

Hiya

Im trying to log the number of complaints that fall outside of a 4 day service level. Our service level is 4 working days and I need to display how many complaints we have on a particular day that have been with us for longer than 4 days. Ive attached an image of what I want to achieve.

At first I thought it would be simple
E12 = D8
E13 = D8
E14 = D8
E15 = D9
E16 = D10

Would this work? Is there any function I could use instead to make take into account public holidays? I was thinking maybe Networkdays but cant think how to use it for this problem

Hello Jemma,

You could probably use WORKDAY function to find your cutoff date. If you have a date in A1 then this formula will give the date 4 working days earlier.

=WORKDAY(A1,-4,holidays)

holidays is optional. This can be a named range which contains a list of your holiday dates.