+ Reply to Thread
Results 1 to 11 of 11

No of days in a Month excluding Sundays

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    139

    No of days in a Month excluding Sundays

    Dear Experts

    May I request the formula for calculating number of days in a month mmm-yy excluding sundays please. I mean for March result is 26 i.e. 31 - 5 sundays

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,078

    Re: No of days in a Month excluding Sundays

    This, maybe?

    =NETWORKDAYS.INTL(EOMONTH(TODAY(),-1)+1,EOMONTH(TODAY(),0),11)

    or, with your lookup date in A1:

    =NETWORKDAYS.INTL(EOMONTH(A1,-1)+1,EOMONTH(TA1,0),11)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    139

    Re: No of days in a Month excluding Sundays

    It is returning output as #NAME?
    The format of A1 is mmm-yy
    Last edited by AliGW; 04-13-2020 at 11:16 AM. Reason: Please don't quote unnecessarily!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,078

    Re: No of days in a Month excluding Sundays

    Ah, sorry - I didn't realise that you have such an old version. The function isn't available to you - sorry. Unfortunately, the NETWORKDAYS function does not have the weekend argument.

  5. #5
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    139

    Re: No of days in a Month excluding Sundays

    If that is not possible, is there way to find number of Sundays

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,078

    Re: No of days in a Month excluding Sundays

    Probably, but I can't help. Sorry! Someone will know - just be patient.

  7. #7
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    139

    Re: No of days in a Month excluding Sundays

    I found this with google help but it returns 4 where as no of sundays is 5 in mar

    =IF(DAY(DATE(YEAR(B1),MONTH(B1),1)+6-WEEKDAY(DATE(YEAR(B2),MONTH(B1),1),3))+28>DAY(EOMONTH(B1,0)),4,5)

  8. #8
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,262

    Re: No of days in a Month excluding Sundays

    Please Login or Register  to view this content.
    Last edited by BMV; 04-13-2020 at 12:26 PM.

  9. #9
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    139

    Re: No of days in a Month excluding Sundays

    Quote Originally Posted by BMV View Post
    Please Login or Register  to view this content.
    What is this for a:a My data is only Mar-20 in Cell B1

  10. #10
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,262

    Re: No of days in a Month excluding Sundays

    try but change b4 to your b1 :-)

    and also
    Please Login or Register  to view this content.
    Last edited by BMV; 04-13-2020 at 12:41 PM.

  11. #11
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    139

    Re: No of days in a Month excluding Sundays

    Quote Originally Posted by BMV View Post
    try but change b4 to your b1 :-)

    and also
    Please Login or Register  to view this content.

    Thank you, it returned 26 excluding sundays in given month. checked for Feb as well Works fine. Grateful to you

+ 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. Counting number of days excluding sundays
    By Don Adeks in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-05-2018, 05:22 PM
  2. How to count days with excluding Sundays and split by month in one?
    By Efendi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2016, 08:32 AM
  3. 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
  4. 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
  5. Replies: 5
    Last Post: 12-11-2012, 01:20 AM
  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. [SOLVED] 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