NETWORKDAYS function
 

Based on MSFT's help for the NETWORKDAYS function (http://
support.microsoft.com/kb/259200) it appears that this function only
works with holidays. Is there an equivalent function that will count
the number of week days (i.e., excluding Saturday and Sunday) between
two dates?

I'm not necessarily interested in excluding holidays but rather
Saturdays and Sundays. The time interval I'm looking at is a decade
or so, so I would rather not, for example, have to create a list of
all days between 1.1.1990 and 12.31.1999, isolate the Saturdays and
Sundays, and use those as the [holidays] argument in the NETWORKDAYS
function.

Thanks for any insights.

Presumably I *could* use SUMPRODUCT on a list of dates/days of the
week as described above. But there's got to be an easier way.

NETWORKDAYS function
 

NETWORKDAYS does exclude weekends (AND holidays if specified).

Read Excel HELP on NETWORKDAYS

"Dave F" wrote:

Based on MSFT's help for the NETWORKDAYS function (http://
support.microsoft.com/kb/259200) it appears that this function only
works with holidays. Is there an equivalent function that will count
the number of week days (i.e., excluding Saturday and Sunday) between
two dates?

I'm not necessarily interested in excluding holidays but rather
Saturdays and Sundays. The time interval I'm looking at is a decade
or so, so I would rather not, for example, have to create a list of
all days between 1.1.1990 and 12.31.1999, isolate the Saturdays and
Sundays, and use those as the [holidays] argument in the NETWORKDAYS
function.

Thanks for any insights.

Presumably I *could* use SUMPRODUCT on a list of dates/days of the
week as described above. But there's got to be an easier way.