Results 1 to 15 of 15

Trying to Calculate SLA on Network days

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2021
    Location
    Gatineau, Canada
    MS-Off Ver
    O365
    Posts
    16

    Trying to Calculate SLA on Network days

    I am trying to Calculate SLA on resolution times.

    Column H - Date/Time Logged - 2022-01-03 07:42:42
    Column I - Date Resolved (sometimes blank) - 2022-01-04 09:00:32
    Column J - Current Date - 2022/01/20 0:00 (would prefer to have this set to 8am on the current date

    I have tried creating this formula
    =IF(ISBLANK(I3),NETWORKDAYS(H3,J3,'Network days'!B510:B523),NETWORKDAYS(H3,I3,'Network days'!B510:B523)) - this was SUPPOSED to calculate the SLA based on if Data resolved is blank and if it is then calculate against today's date.
    I receive a #value! error
    Business hours are 8am - 2pm, no weeekends & no stats are included.

    I'm not new to excel but only familiar with basics, some formulas. I have been doing some research and just can't finalize this. I'm in a new role that will require specific SLA calculations, really would appreciate some assistance. I have the spreadsheet I am using and can share if necessary.

    Thank you in advance.
    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] Edit VBA to calculate network days between different dates.
    By steve400243 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2020, 04:07 PM
  2. Network days
    By melissaoi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-23-2017, 09:32 AM
  3. [SOLVED] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  4. network days
    By fentiger79 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2014, 04:54 PM
  5. [SOLVED] Subtracting Hold Days from Network Days Formula
    By david1987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2012, 08:30 AM
  6. Network days
    By fithawk in forum Excel General
    Replies: 13
    Last Post: 11-05-2011, 06:17 PM
  7. Network Days
    By dinadvani via OfficeKB.com in forum Excel General
    Replies: 3
    Last Post: 07-21-2006, 06:10 AM

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