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.

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

"CBP Bob" <CBP wrote in message
...
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.