+ 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 Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    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
    791

    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... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,858

    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



+ 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. 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