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!