This will count Saturdays with start date in A1 and end date in B1

=SUM(INT((WEEKDAY(A1-7)+B1-A1)/7))


this will count all days except Sundays

=SUM(INT((B1-WEEKDAY(A1+1-{2;3;4;5;6;7})-A1+8)/ 7))


this will count holidays with the holidays in L1:L12



=SUMPRODUCT(--(L1:L12=A1),--(L1:L12<=B1),--(WEEKDAY(L1:L12)<1))


so it can be used to subtract holidays if you are using the second formula


--
Regards,

Peo Sjoblom



"Robert" wrote in message
...
i am trying to calculate how many days between 2 dates that excludes
holidays, but includes saturdays. Networkdays is only for 5 day work
weeks...i need it to be for 6 day work weeks.