Results 1 to 4 of 4

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. #1
    New Member
    Join Date
    Sep 2010
    Posts
    1

    Default 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?

    Thanks in advance!

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    68,983

    Default Re: Average of Networkdays

    Welcome to the Board.

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

  3. #3
    shg
    shg is online now
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    14,397

    Default 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. #4
    MrExcel MVP
    Moderator
    barry houdini's Avatar
    Join Date
    Mar 2005
    Location
    England
    Posts
    19,914

    Default 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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com