How To Use 2 Formulas In One Cell In Excel Excel Tip – Using The Workday Function To Calculate Status Of An SLA

You are searching about How To Use 2 Formulas In One Cell In Excel, today we will share with you article about How To Use 2 Formulas In One Cell In Excel was compiled and edited by our team from many sources on the internet. Hope this article on the topic How To Use 2 Formulas In One Cell In Excel is useful to you.

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

This article explains how to use the WORKDAY function with the IF function to calculate how many workdays have passed from one date to another.

I don’t know about you, but our IT department has a Service Level Agreement (SLA) of eight days. That’s eight business days, so we can’t look to them for updates until that time has passed. So how can we quickly find out with Excel how long it’s been since the call was logged and if the case is still outside the agreed upon SLA?

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

Let’s look at an example that calculates how many days have passed since this IT call was logged. Today’s date is August 4, 2015. We logged an IT call on July 27, 2015. So if we used the formula below

=TODAY()-B3

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

That’s all well and good, but if we only have to worry about the days that IT would be working (in which case we specify that Saturday and Sunday are off), we need to add a little more to our formula. Days off are taken into account, so they are not taken into account in the calculation.

So, back to our logged IT call. We know that the threshold is 8 days off. We can then show Excel if the difference between the date the call was logged and the current date exceeds this threshold of 8. If it is, it is out of SLA, and if it is less than or equal to 8 business days, it is in SLA.

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

=IF(B3<=WORKDAY(TODAY(),-8),"out of SLA","within SLA")

The logic behind the formula is that if the date in cell B3 is less than or equal to 8 business days from today’s date (not Saturday or Sunday) it will display out of SLA, if this logic is false it will display within SLA. This formula gives us a result of 7.

So now we know if IT can be contacted as they are outside the agreed SLA to change my IT request.

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

Video about How To Use 2 Formulas In One Cell In Excel

You can see more content about How To Use 2 Formulas In One Cell In Excel on our youtube channel: Click Here

Question about How To Use 2 Formulas In One Cell In Excel

If you have any questions about How To Use 2 Formulas In One Cell In Excel, please let us know, all your questions or suggestions will help us improve in the following articles!

The article How To Use 2 Formulas In One Cell In Excel was compiled by me and my team from many sources. If you find the article How To Use 2 Formulas In One Cell In Excel helpful to you, please support the team Like or Share!

Rate Articles How To Use 2 Formulas In One Cell In Excel

Rate: 4-5 stars
Ratings: 2871
Views: 56554026

Search keywords How To Use 2 Formulas In One Cell In Excel

How To Use 2 Formulas In One Cell In Excel
way How To Use 2 Formulas In One Cell In Excel
tutorial How To Use 2 Formulas In One Cell In Excel
How To Use 2 Formulas In One Cell 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

Bài viết đã được tạo 2736

Bài liên quan

Bắt đầu nhập từ khoá bên trên và nhấp enter để tìm kiếm. Nhấn ESC để huỷ.

Trở lên trên