# Average of Networkdays

This is a discussion on Average of Networkdays within the Excel Questions forums, part of the Question Forums category; Good afternoon everyone, I am trying to figure out a formual that would allow me to calculate the average number ...

1. ## Average of Networkdays

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?

2. ## Re: Average of Networkdays

Welcome to the Board.

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

3. ## Re: Average of Networkdays

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.

4. ## Re: Average of Networkdays

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•