Does networkdays have a six day week?

C

CBP Bob

Networkdays works fine to capture a five day week. Our Academy is on a Monday
thru Saturday schedule. I need a way to calculate the number of workdays in a
six day week that will exclude all Sundays. I also need to be able to use the
exclude portion of the function to exclude holidays.
 
B

Bob Phillips

=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/7))-
SUMPRODUCT(ISNUMBER(MATCH(WEEKDAY(holidays),{2;3;4;5;6;7},0))*(holidays>=start_date)*(holidays<=end_date))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top