July 22, 2024


Welcome to the core

Working out SLA Breaches with Excel!

Looking for a simple way to keep track of task and dates?

This will help you keep track of SLA’s for a given task, log or project, when handy when dealing with a selection of items.

We will guess that the threshold is 8 working days, we can then get Excel to display if the date difference from when the call was logged to the current date is over 8 working days then it is out of SLA and if it is under or equal to 8 working days it is within SLA.

HEre is how it would look using the IF statement.

=IF(B3<=WORKDAY(TODAY(),-8),”Breached SLA”,”Within SLA”)

This concept can be used for other date tracking tasks as well!

If you get stuck just leave a comment!

Copyright © All rights reserved. | Newsphere by AF themes.