+ Reply to Thread
Results 1 to 6 of 6

How to count days with excluding Sundays and split by month in one?

  1. #1
    Registered User
    Join Date
    06-26-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    21

    How to count days with excluding Sundays and split by month in one?

    Hello Excel friends,

    I would like to ask for a help:
    Lets say there is a time period from 18/06/2016 till 20/12/2016. What I would need is to calculate:
    - number of days for each month (June, July, Aug, Sep, Oct, Nov and Dec)
    - with condition that Sundays are excluded

    I tried to solve this using formulas, but with no result. Any idea please? Thank you, Marian

    formula.jpg
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to count days with excluding Sundays and split by month in one?

    Try

    =MAX(0,NETWORKDAYS.INTL(MAX($B$3,C7),MIN($C$3,EOMONTH(C7,0)),11))


    FYI, formula for K3 could be
    =NETWORKDAYS.INTL(B3,C3,11)

  3. #3
    Registered User
    Join Date
    06-26-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: How to count days with excluding Sundays and split by month in one?

    Wau, thank you Jonmo for fast and so useful answer! NETWORDDAYS and NETWORKDAYS.INTL are new functions for me, never used before.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to count days with excluding Sundays and split by month in one?

    You're welcome.

  5. #5
    Registered User
    Join Date
    06-26-2009
    Location
    Slovakia
    MS-Off Ver
    Excel 2010
    Posts
    21

    Re: How to count days with excluding Sundays and split by month in one?

    Hello guys, I just found I would need additional help here please. Could you please advice how to change the formula so that it would exclude not only Sundays, but also some specific days, which are bank holiday in our country?
    For example from the period 18/06/2016 - 20/12/2016, how to count number of days with excluding Sundays AND excluding 01/09/2016, 15/09/2016 and 01/11/2016. Thank you, Marian

  6. #6
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: How to count days with excluding Sundays and split by month in one?

    Make a list of the holidays to exclude in a range of cells, say $E$2:$E$20

    =MAX(0,NETWORKDAYS.INTL(MAX($B$3,C7),MIN($C$3,EOMONTH(C7,0)),11,$E$2:$E$20))

+ 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. To calculate number of days excluding sundays
    By palani_k15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2014, 09:02 AM
  2. Count Days EXCLUDING ONLY Sundays and a named range for Holidays
    By Seaplane Jack in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-14-2014, 05:03 PM
  3. [SOLVED] Count the days excluding Friday in every month using a date range.
    By miss_chloe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2013, 10:42 AM
  4. Replies: 5
    Last Post: 12-11-2012, 01:20 AM
  5. Replies: 0
    Last Post: 04-03-2008, 10:15 PM
  6. counting days excluding saturdays and sundays
    By p_dhoke in forum Excel General
    Replies: 2
    Last Post: 04-24-2007, 04:34 AM
  7. Excel - list days of a month, excluding Sundays
    By John in forum Excel General
    Replies: 1
    Last Post: 01-03-2006, 12:50 PM

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