+ Reply to Thread
Results 1 to 2 of 2

Count Workday include Saturday

  1. #1
    Registered User
    Join Date
    11-23-2005
    Posts
    1

    Count Workday include Saturday

    I would like to return the total number of days including saturday excluding sunday between two dates. We have a 6day work week and to calulate items per week would need the result of days based on 6 day work week between 2 dates. Can anyone help - I noticed that this has been posted before but I was not able to locate any reply.
    Thank you

  2. #2
    Bob Phillips
    Guest

    Re: Count Workday include Saturday

    =SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/
    7))

    This formula is inclusive, just as NETWORKDAYS is, so if you don't want
    that, subtract 1.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "TCLehmann" <TCLehmann.1yyx6m_1132780201.3617@excelforum-nospam.com> wrote
    in message news:TCLehmann.1yyx6m_1132780201.3617@excelforum-nospam.com...
    >
    > I would like to return the total number of days including saturday
    > excluding sunday between two dates. We have a 6day work week and to
    > calulate items per week would need the result of days based on 6 day
    > work week between 2 dates. Can anyone help - I noticed that this has
    > been posted before but I was not able to locate any reply.
    > Thank you
    >
    >
    > --
    > TCLehmann
    > ------------------------------------------------------------------------
    > TCLehmann's Profile:

    http://www.excelforum.com/member.php...o&userid=29047
    > View this thread: http://www.excelforum.com/showthread...hreadid=487773
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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