stephi0330
New Member
- Joined
- Sep 29, 2010
- Messages
- 1
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!
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!