How do I set NETWORKDAYS to regard friday and saturday as weekend

The NETWORKDAYS function regards Saturday and Sunday as weekends. I need to
set Excel to regard Friday and Saturday as the weekend.

Hi!

Try this:

A1 = start date
A2 = end date

=NETWORKDAYS(A1+1,A2+1)

If you need to exclude holidays:

H1:H10 = list of holiday dates

Entered as an array using the key combination of CTRL,SHIFT,ENTER.

=NETWORKDAYS(A1+1,A2+1,H1:H10+1)

Biff

"Shay.C." <Shay.C.@discussions.microsoft.com> wrote in message
news:8A9FBEA5-9E73-485A-9CB8-10D7D567C293@microsoft.com...
> The NETWORKDAYS function regards Saturday and Sunday as weekends. I need
> to
> set Excel to regard Friday and Saturday as the weekend.