Results 1 to 13 of 13

Formula to Account for Weekend Days for an SLA

Threaded View

SweetBaboo Formula to Account for... 02-25-2025, 10:31 AM
krackers Re: Formula to Account for... 02-25-2025, 10:49 AM
SweetBaboo Re: Formula to Account for... 02-25-2025, 11:05 AM
etaf Re: Formula to Account for... 02-25-2025, 10:50 AM
SweetBaboo Re: Formula to Account for... 02-25-2025, 12:14 PM
krackers Re: Formula to Account for... 02-25-2025, 01:10 PM
SweetBaboo Re: Formula to Account for... 02-25-2025, 01:30 PM
etaf Re: Formula to Account for... 02-25-2025, 11:08 AM
AliGW Re: Formula to Account for... 02-25-2025, 01:14 PM
SweetBaboo Re: Formula to Account for... 02-25-2025, 01:30 PM
krackers Re: Formula to Account for... 02-25-2025, 01:40 PM
SweetBaboo Re: Formula to Account for... 02-25-2025, 01:56 PM
krackers Re: Formula to Account for... 02-25-2025, 02:56 PM
  1. #1
    Registered User
    Join Date
    05-15-2020
    Location
    North America
    MS-Off Ver
    Office365 (v2209)
    Posts
    35

    Formula to Account for Weekend Days for an SLA

    Hi, I need some help trying to figure out the best way to calculate the weekend days for a service level agreement. It's for a radiology center. The center has an SLA with radiologists to interpret images within 1 business day from the date the images are uploaded to the radiology system. Many of these radiologists work on the weekends. Sometimes they will get images uploaded on a Friday and will interpret on the weekend. Or, images uploaded on Saturday or Sunday and interpreted on Monday or Tuesday. An image uploaded on a Friday or Saturday but interpreted on a Monday is still 1 business day. Then there are federal holidays to take into account but I can put that aside if it's too complicated. I need a formula that will subtract the days of the weekend but I'm not sure how to go about it. I attached an example of the spreadsheet and would appreciate some input.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] network days formula not handling cases when start date is weekend
    By FireDept in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-04-2024, 10:30 AM
  2. Replies: 4
    Last Post: 01-13-2023, 07:59 AM
  3. [SOLVED] Formula to add days with holiday & weekend
    By jackson_hollon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2019, 04:29 AM
  4. [SOLVED] Formula to count the days between the ranges exclude weekend
    By roven.aravind in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2018, 04:04 AM
  5. Formula to Remove Weekend Days
    By Tom in forum Excel General
    Replies: 1
    Last Post: 05-24-2006, 11:35 AM
  6. Excel running date formula minus weekend days
    By Eliane in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-30-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1