Posted to microsoft.public.excel.misc

Lyn

external usenet poster

Posts: 35

Networkdays

This function works great if I don't try to exclude the holiday....Here's my
problem, I have columns for the entire month and I need to calculate the
number of weekdays AND the number of weekdays less the holidays....this works
fine if my holidays are in a row i.e. 12/24 and 12/25 (AV5:AV6); however, if
I would like to take the 31st out also, it gives me the #value signal....any
help out there?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Networkdays	StephanieH	Excel Discussion (Misc queries)	2	February 28th 07 06:33 PM
NETWORKDAYS	albertmb	Excel Discussion (Misc queries)	3	March 13th 06 09:33 PM
networkdays	kevt	Excel Worksheet Functions	1	September 8th 05 02:23 PM
Help on Networkdays	Susan Hayes	Excel Worksheet Functions	1	September 8th 05 03:34 AM
NETWORKDAYS Help	rsteiner1	Excel Worksheet Functions	0	August 10th 05 07:08 PM

All times are GMT +1. The time now is 07:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us