View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
 
Posts: 187
Default 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.