Can you provide the expected results for that fourth column?

In article ,
"Seymour" wrote:

I am trying to calculate a monthly average of workdays between the dates in
these columns. I'd like to do all calculations on another (protected)
worksheet as multiple users are entering the dates. For most of the other
data collected I accomplished this with array formulae. Do you have any idea
how I might do it with this one?
Thanks,
Cassandra


"Domenic" wrote:

As far as I know, NETWORKDAYS doesn't work with arrays...

In article ,
"Seymour" wrote:

Does NETWORKDAYS work with arrays?

The third column uses NETWOKDAYS(Q3,P3). The fourth column uses the
ranges
(either as named ranges or Q3:Q6, P3:P6) and the array command
(Ctrl+Shift+Enter). I cannot get any permutation of the fourth column to
work and I suspect NETWORKDAYS does not work with arrays. Please,
someone
tell me I'm wrong!

5/10/2005 5/12/2005 3 #VALUE!
4/28/2005 6/10/2005 32 #VALUE!
4/25/2005 6/15/2005 38 #VALUE!
4/8/2005 8/8/2005 87 #VALUE!