Count Workday include Saturday

T

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
 
B

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)
 
Top