Seymour

Posts: n/a

Has anyone successfully used NETWORKDAYS with arrays?

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!

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3D Arrays	DB	Excel Worksheet Functions	2	October 10th 05 03:50 PM
Confused about arrays and ranges in functions	Llurker	Excel Worksheet Functions	0	July 7th 05 05:44 AM
Comparing Arrays	TangentMemory	Excel Discussion (Misc queries)	2	May 13th 05 05:06 PM
How to use linest with variably sized data arrays?	[email protected]	Excel Worksheet Functions	0	April 13th 05 04:56 PM
MS Excel Function - Networkdays	Nilesh Inamdar	Excel Worksheet Functions	3	November 26th 04 07:10 PM

All times are GMT +1. The time now is 08:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us