Zewer,

Try this

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

--
HTH

Bob Phillips

"Zewer" wrote in message
...
I have a problem working with this function:

NETWORKDAYS(start_date,end_date,holidays)

This function calculates the number of "Working Dates" between any two
given
dates. My problem is that this function calculates Saturday and Sunday as
none-working days, but in the country I'm working in, we have Friday and
Saturday as our none-working days. Therefore, it gives an inconsistent
answer. Do you have any idea if can I make the function start calculating
Friday and Saturday as the official none-working days?!