+ Reply to Thread
Results 1 to 3 of 3

Differance Networkdays vs Workdays

  1. #1
    Registered User
    Join Date
    08-24-2015
    Location
    Derby
    MS-Off Ver
    2010
    Posts
    2

    Differance Networkdays vs Workdays

    Hi

    Networkdays calculates how many day are between two dates
    Workdays calculates the end date from the start date by the amount of days specified

    However they seam to calculate differently

    if you do =networkdays(A1,A2) where A1 is 14/09/2015 and A2 is 17/09/2015 it returns 4 days (seams correct)

    Then do = workdays(A1,4) it gives the date as the 18/09/2015 not the 17th as you would expect

    Doesn't matter the exact date you use the result is the same ie they are one day out to each other.

    I'm guessing one counts today and the other doesn't but that really shouldn't happen should it?

    Anyone know why?

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,033

    Re: Differance Networkdays vs Workdays

    It's based on definition will you use todays date or not.
    Since they defined differently you need to use -1 in workdays function to get same result.
    Never use Merged Cells in Excel

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,033

    Re: Differance Networkdays vs Workdays

    Just be carefull where to put -1.
    Not outside the function but within.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Computing the differance between two Northing and Eastings
    By RRien07 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-12-2015, 12:50 PM
  2. Calculate Time differance in label
    By amolryeolekar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2012, 01:08 PM
  3. Date Differance collection
    By plopleuk in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-04-2009, 01:39 AM
  4. Tracking Time Differance
    By BigEye64 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 11-21-2008, 12:26 AM
  5. how to use workdays or networkdays in VBA
    By ABG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2006, 03:45 AM
  6. Using Rank with ties and spliting the differance
    By assws in forum Excel General
    Replies: 6
    Last Post: 07-29-2005, 10:09 AM
  7. [SOLVED] Formula for finding the differance between two times
    By DP01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-03-2005, 09: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