+ Reply to Thread
Results 1 to 7 of 7

# of Workdays minus Holidays

  1. #1
    Registered User
    Join Date
    10-09-2007
    Posts
    4

    # of Workdays minus Holidays

    When trying to find the number of workdays between two dates minus holidays, excel says to use NETWORKDAYS(start_date,end_date,holidays). I tried this and ended up getting one less day regardless if the holiday fell between the two dates. I made sure that the dates weren't formatted as text. What am I doing wrong?

    Thanks!
    Last edited by VBA Noob; 10-11-2007 at 10:56 AM.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    See other question

    http://www.excelforum.com/showthread.php?t=618027
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Can you give an example?

    What formula are you using, exactly. What are the start and end dates and holidays and result?

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    NETWORKDAYS

    This function will calculate the number of working days between two dates, the calculation does not include the last day so try

    =NETWORKDAYS(Start,End,Holidays)+1

  5. #5
    Registered User
    Join Date
    10-09-2007
    Posts
    4
    Perfect thanks!

  6. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Quote Originally Posted by jmozulay
    Perfect thanks!
    ?? Are you sure ??

    Networkdays actually counts both the start and end dates (assuming they are not Sats, Suns or defined holidays)

    so if I use this formula

    =NETWORKDAYS(Start,End,Holidays)+1

    where Start is today (a Thursday) and End is tomorrow (a Friday) the result will be 3

  7. #7
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Yes you're right daddylonglegs

    Please Login or Register  to view this content.
    That's where I was going wrong. Its probably best to format the date cells to "ddd dd-mmm-yy" or something like that so that you can see the actual weekdays

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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