Formula For Less Than Or Equal To In Excel Excel Tip – Using The Workday Function To Calculate Status Of An SLA

You are searching about Formula For Less Than Or Equal To In Excel, today we will share with you article about Formula For Less Than Or Equal To In Excel was compiled and edited by our team from many sources on the internet. Hope this article on the topic Formula For Less Than Or Equal To In Excel is useful to you.

Excel Tip – Using The Workday Function To Calculate Status Of An SLA

This article will explain how to use the WORKDAY function combined with the IF function to calculate how many work days have elapsed from one date to another date.

I don’t know about you, but our IT department at work has a Service Level Agreement(SLA) turnaround time of eight days. That is eight working days, so we cannot really chase them for any updates until that time has elapsed. So how can we quickly work out with Excel how long it has been since we logged the call and if the incident is still within our outside of the agreed SLA?.

So, we could try to use the usual TODAY() function which is useful for calculating intervals between a specified date and the current date.

Let’s take a look at an example calculating how many days it has been since we logged that IT call. Todays date is August 4th 2015. We logged an IT call on the 27th July 2015. So if we used the formula below

=TODAY()-B3

(our date the call was logged is contained in cell B3). This would result in 9 days.

That is all well and good but if we need to only be concerned with days IT would be working (in this case we are specifying Saturday and Sunday are non working days), we need to add a little bit more to our formula to take into account the non working days, so they are disregarded in the calculation.

So, back to our IT call we logged. We know that the threshold is 8 available 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 this threshold. If it is then it is out of SLA and if it is under the 8 working days or equal to 8 working days it is within SLA.

Let’s go ahead and build our formula starting with an IF function

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

The logic of the formula is if the date in cell B3 is less than or equal to today’s date by 8 Workdays (not Saturday or Sunday), then display Out Of SLA, if this logic is false then display Within SLA. This formula gives us a result of 7.

So we now know if the IT department can be contacted because they are outside of the their agreed SLA for turning around my IT query.

This is a really useful formula for many uses including project tracking of dates and milestones.

Video about Formula For Less Than Or Equal To In Excel

You can see more content about Formula For Less Than Or Equal To In Excel on our youtube channel: Click Here

Question about Formula For Less Than Or Equal To In Excel

If you have any questions about Formula For Less Than Or Equal To In Excel, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Formula For Less Than Or Equal To In Excel was compiled by me and my team from many sources. If you find the article Formula For Less Than Or Equal To In Excel helpful to you, please support the team Like or Share!

Rate Articles Formula For Less Than Or Equal To In Excel

Rate: 4-5 stars
Ratings: 6788
Views: 9546649 4

Search keywords Formula For Less Than Or Equal To In Excel

Formula For Less Than Or Equal To In Excel
way Formula For Less Than Or Equal To In Excel
tutorial Formula For Less Than Or Equal To In Excel
Formula For Less Than Or Equal To In Excel free
#Excel #Tip #Workday #Function #Calculate #Status #SLA

Source: https://ezinearticles.com/?Excel-Tip—Using-The-Workday-Function-To-Calculate-Status-Of-An-SLA&id=9135645