+ Reply to Thread
Results 1 to 4 of 4

count days excluding only sunday

  1. #1
    Registered User
    Join Date
    01-18-2014
    Location
    bangalore, india
    MS-Off Ver
    Excel 2010
    Posts
    14

    count days excluding only sunday

    how to count days excluding only sundays in a calender period.

    "weekdays" excludes both saturdays and sundays.

    thnks in advance

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: count days excluding only sunday

    Sinc you have Excel 2010
    With
    A1: start date.....01-Dec-2012
    A2: end date.......31-Dec-2012

    This regular formula returns the count of non-Sunday days in that date range:
    Please Login or Register  to view this content.
    Note: the "1000000" code flags 0's for workdays and 1's for non-workdays.

    EDITED TO INCLUDE THIS Pre-XL2010 ALTERNATIVE:
    Regular formula:
    A4: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<>1))

    For days to skip: 1=Sun, 2=Mon, 3=Tue, 4=Wed, 5=Thu, 6=Fri, 7=Sat

    Is that something you can work with?
    Last edited by Ron Coderre; 06-05-2014 at 01:42 PM.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: count days excluding only sunday

    Another way....
    Try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter.

    Assuming A1= Start Date and A2=End Date, then

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: count days excluding only sunday

    Or this Regular Formula.......

    Please Login or Register  to view this content.

+ 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. [SOLVED] No. of days between 2 dates (excluding Sunday)
    By K.Raja in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2014, 06:25 AM
  2. [SOLVED] count the day excluding Sunday only
    By miss_chloe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-23-2013, 02:37 AM
  3. [SOLVED] Formula for Last 30 Days Excluding Saturday, but including Sunday
    By AlphaSkidz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2013, 02:23 PM
  4. Looking for some kind of a calendar which numbering days excluding Saturday and Sunday
    By rogerthatman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2012, 07:52 AM
  5. Adding days but excluding Sunday's
    By davidingilbert in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-03-2009, 06:55 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