+ Reply to Thread
Results 1 to 3 of 3

Networkdays - excluding weekend and custom list of dates

  1. #1
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    91

    Question Networkdays - excluding weekend and custom list of dates

    I am trying to figure out simple way of calculating number of days between two dates excluding the weekend (Saturday and Sunday) and excluding a list of custom dates
    So lets say we have start date 12/01/2018 and end date 12/05/2018 (mm/dd/yyyy) and we have in our custom date list 12/04/2018 that needs to be excluded - the formula should consider the weekend and all the custom dates that are between start and end date and calculate the difference - in this example we have first and second December weekend days and 1 custom date - so the result should be 2

    A1 = start date
    A2 = end date
    A3 = RESULT


    B1:B10 = list of custom dates to be excluded from counting the difference between A1 and A2
    Last edited by godlev; 12-05-2018 at 06:39 AM. Reason: solved
    Truth fears no questions.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: Networkdays - excluding weekend and custom list of dates

    Just try this:

    =NETWORKDAYS(A1,A2,B1:B10)

    you may need ; instead of ,
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    09-02-2011
    Location
    Bulgaria
    MS-Off Ver
    2013
    Posts
    91

    Re: Networkdays - excluding weekend and custom list of dates

    awesome ! - i never thought that for holidays we can give range with custom dates
    thank you - this is solved!

+ 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. [SOLVED] Networkdays change weekend from Sat, Sun to either Fri, Sat or Fri in Excel 2007
    By JEETKAMALARORA in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2022, 12:53 AM
  2. [SOLVED] Count Unique Number of Dates, Excluding Designated Holidays and Weekend Dates
    By Winship in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-07-2017, 08:37 AM
  3. [SOLVED] Require a formula to count unique dates excluding weekend dates
    By john dalton in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2015, 09:17 AM
  4. [SOLVED] VBA code for excluding weekend dates from Web import into Excel
    By vk2013 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-29-2013, 04:15 PM
  5. 2 dates difference, NETWORKDAYS, custom working hours.
    By yupo72 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2013, 10:21 AM
  6. Identifying weekend dates in a list of dd/mm/yy dates
    By Gooford in forum Excel General
    Replies: 4
    Last Post: 01-07-2010, 10:01 AM
  7. How do I set NETWORKDAYS to regard friday and saturday as weekend
    By Shay.C. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-10-2006, 03:29 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