+ Reply to Thread
Results 1 to 4 of 4

To calculate number of days excluding sundays

  1. #1
    Registered User
    Join Date
    11-22-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    1

    To calculate number of days excluding sundays

    All,


    I just wan to know to calculate the number of days excluding sundays. I've actually used networkdays but unable to calculate excluding sundays alone for a date range.

    Help me out in this.


    Thanks,
    Palani

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: To calculate number of days excluding sundays

    In Excel 2010 and later you can use NETWORKDAYS.INTL to count days between two dates excluding Sunday only, i.e.

    =NETWORKDAYS.INTL(A2,B2,11)

    In earlier versions of excel you can use this formula to get the same result

    =B2-A2-INT((1-WEEKDAY(B2)+B2-A2)/7)
    Audere est facere

  3. #3
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: To calculate number of days excluding sundays

    I would guess by taking the difference of days and dividing by 7 you would get the sunday count... probably round down

    Something like this...
    =RoundDown((Date1-Date2)-((Date1-Date2)/7),0)

    All theory, but looking at that on here it logically makes sense...would have to verify though
    -If you think you are done, Start over - ELeGault

  4. #4
    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
    43,895

    Re: To calculate number of days excluding sundays

    An alternative:

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


    assuming your two dates are in A1 (first date) and A2 (second date). The 1 at the end specifies Sunday. You can exclude other days by changing it to 2 = Monday, 3 =Tuesday, etc.
    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

+ 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. 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
  2. Replies: 5
    Last Post: 12-11-2012, 01:20 AM
  3. Replies: 1
    Last Post: 08-22-2012, 10:38 AM
  4. counting days excluding saturdays and sundays
    By p_dhoke in forum Excel General
    Replies: 2
    Last Post: 04-24-2007, 04:34 AM
  5. [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

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