+ Reply to Thread
Results 1 to 3 of 3

Counting number of days excluding sundays

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    Nigeria
    MS-Off Ver
    2007
    Posts
    58

    Counting number of days excluding sundays

    Hello guys,

    So in my business, we work Mondays through Saturdays. I need a formula in cell B3 that will help me calculate the number of days (Monday to Saturday) between starting date in B1 and ending date in B2, both starting and ending days inclusive.

    This means only Sundays will be exempted. There is a little tweak needed however. We work half day on Saturdays, so I want every Saturday reached to be calculated as half day while Mondays-Fridays are full days.

    Kindly help me out gurus in the house.

    PS: I will need explanations on the formula so I can replicate it when needed.

    Thanks in advance.

    Don Adeks.

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Counting number of days excluding sundays

    Try this:

    =NETWORKDAYS(B1,B2)+INT((WEEKDAY(B1-7)-B1+B2)/7)/2

  3. #3
    Registered User
    Join Date
    08-28-2014
    Location
    Nigeria
    MS-Off Ver
    2007
    Posts
    58

    Re: Counting number of days excluding sundays

    Hello 63falcondude,

    Thanks for this. It worked. I'm so grateful.

+ 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. 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
  2. Replies: 10
    Last Post: 04-27-2015, 06:33 PM
  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. 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