Average of Networkdays

[stephi0330]

Good afternoon everyone,

I am trying to figure out a formual that would allow me to calculate the average number of working days between two columns. So far, I have this, which works:

=AVERAGE(NETWORKDAYS(D1, E1,HOLS)),(NETWORKDAYS(D2,E2,HOLS)), NETWORKS(D3,E3,HOLS))

Problem is, I have AT LEAST 50 more cells of networkdays to add to the formula, which would make it impossibly long. Is there a shorter way of doing this?

Thanks in advance!

 

[Andrew Poulsom]

Welcome to the Board.

Why don't you put NETWORKDAYS formulas in a spare column and average the results?

 

[shg]

Networkdays is not array-compatible, so it would be easiest to just enter the formula in a convenient column, copy it down, and take the average of the column.

 

[barry houdini]

In Excel 2007 and later NETWORKDAYS will accept an array (not a range) so this formula works

=AVERAGE(NETWORKDAYS(D1:D50+0,E1:E50+0,HOLS))

confirmed with CTRL+SHIFT+ENTER

because of the +0 you can't have any text values in the ranges