Count Workday include Saturday

[TCLehmann]

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

[Bob Phillips]

=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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>