Results 1 to 15 of 15

Trying to Calculate SLA on Network days

Threaded View

  1. 01-20-2022, 11:58 AM #3
    H1ghway
    H1ghway is offline
    Registered User
    Join Date
    11-15-2021
    Location
    Gatineau, Canada
    MS-Off Ver
    O365
    Posts
    16

    Re: Trying to Calculate SLA on Network days

    It's because I copied it from another worksheet but left out some identifying cells (nothing relevant to the calculation) so the dates are in e, f, g, sorry for the confusion

    I modified it to reflect the correct cells
    =IF(ISBLANK(F3),NETWORKDAYS('Network Days'!A2:A14, E3,G3),NETWORKDAYS('Network Days'!A2:A14, E3,H3))
    Last edited by H1ghway; 01-20-2022 at 12:02 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1