+ Reply to Thread
Results 1 to 2 of 2

DAYS vs. NETWORKDAYS (Updating an existing formula)

  1. #1
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2016 Professional
    Posts
    388

    DAYS vs. NETWORKDAYS (Updating an existing formula)

    DAYS vs. NETWORKDAYS

    How would I adjust these formula's to use actual days and NOT NETWORKDAYS:
    =IF( OR( BN3236 ="", P3236 = "", NETWORKDAYS(BN3236,O3236)<0 ),-1, NETWORKDAYS(BN3236,O3236))
    =IF( OR( BO3236 ="", BA3236 = "", NETWORKDAYS(BO3236,BA3236)<0 ),-1, NETWORKDAYS(BO3236,BA3236))

    Thank you!

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: DAYS vs. NETWORKDAYS (Updating an existing formula)

    You could try

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help adding "networkdays" to an existing formula
    By Canvasshoes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-21-2013, 05:39 PM
  2. [SOLVED] Formula for updating 30.60.90 days past due that updates for new entries
    By RArchie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-13-2013, 08:35 PM
  3. Replies: 2
    Last Post: 02-10-2013, 05:17 PM
  4. Replies: 7
    Last Post: 05-28-2012, 12:18 PM
  5. Replies: 1
    Last Post: 01-12-2012, 06:10 PM
  6. Replies: 1
    Last Post: 08-15-2009, 05:52 AM
  7. [SOLVED] how to use networkdays returning fractions of days (4.3 days)
    By Chris in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-06-2005, 11:05 AM
  8. [SOLVED] What is the formula for adding a number of days to an existing dat
    By Ivan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-03-2005, 10:06 PM

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