Excel Formula For Number For Days Of Days To Date Excel Tip – Using The Workday Function To Calculate Status Of An SLA

You are searching about Excel Formula For Number For Days Of Days To Date, today we will share with you article about Excel Formula For Number For Days Of Days To Date was compiled and edited by our team from many sources on the internet. Hope this article on the topic Excel Formula For Number For Days Of Days To Date 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 in combination with the IF function to calculate how many workdays have passed from one date to the next.

I don’t know about you, but our IT department at work has a service level agreement (SLA) turnaround time of eight days. That’s eight working days, so we can’t really follow up on any updates until after that time. So how can we quickly work with Excel to see how long it’s been since we logged a call and if the incident is still ours outside the agreed SLA?.

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

Let’s look at an example where we count how many days it has been since that IT call was logged. Today’s date is 4th August 2015. We took IT call on 27th July 2015. So if we use the formula below

= today ()-B3

(Our date the call was logged is contained in cell B3). It will result in 9 days.

That’s all well and good but if we only need to be concerned with the days that IT works (in this case we’re specifying Saturday and Sunday as non-working days), we need to add a little to our formula for taking. Count non-working days, so they are ignored in the calculation.

So, back to our IT call we logged on. Since we know that the threshold is 8 available days, we can then get Excel to display if the difference between the date the call was logged to the current date is above this threshold 8. If it is then it is out of SLA and if it is less than 8 working days or equal to 8 working days then it is within SLA.

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

=IF(B3<=WORKDAY(today(),-8), "outside 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 working days (not Saturday or Sunday), then display outside of SLA, if this logic is false then display within SLA. This formula gives us a result of 7.

So now we know that the IT department can be contacted because they are outside of their agreed SLA to turn around my IT query.

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

Video about Excel Formula For Number For Days Of Days To Date

You can see more content about Excel Formula For Number For Days Of Days To Date on our youtube channel: Click Here

Question about Excel Formula For Number For Days Of Days To Date

If you have any questions about Excel Formula For Number For Days Of Days To Date, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Excel Formula For Number For Days Of Days To Date was compiled by me and my team from many sources. If you find the article Excel Formula For Number For Days Of Days To Date helpful to you, please support the team Like or Share!

Rate Articles Excel Formula For Number For Days Of Days To Date

Rate: 4-5 stars
Ratings: 1072
Views: 38739332

Search keywords Excel Formula For Number For Days Of Days To Date

Excel Formula For Number For Days Of Days To Date
way Excel Formula For Number For Days Of Days To Date
tutorial Excel Formula For Number For Days Of Days To Date
Excel Formula For Number For Days Of Days To Date 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