Networkdays function help

M

MattG

Hi all,

After your prompt success helping me before, I'm back for more help.

I want to include all the public holidays in the function, I tried
selecting a few cells with the dates in, but that didn't work. It moved
the cell array on for each row, bugger.

So I want a list of dates in the function:

=NETWORKDAYS(B3,H3,2/1/6)
This works, so how do I add further details in? I imagine it's just a
matter of syntax, I've tried comma, semicolon, colon, quotes and no
quotes, but this hasn't worked.

Anyone shed some light on this?
 
J

JE McGimpsey

Perhaps I'm confused, but if your holiday list is in, say, J1:J10,
couldn't you use:


=NETWORKDAYS(B3, H3, $J$1:$J$10)

in order to prevent the holiday cells from "moving"?
 
M

MattG

JE said:
Perhaps I'm confused, but if your holiday list is in, say, J1:J10,
couldn't you use:


=NETWORKDAYS(B3, H3, $J$1:$J$10)

in order to prevent the holiday cells from "moving"?
Click to expand...

Excellent, as you can probably tell, I'm a bit of a newbie to using
Excel. Well, using spreadsheets at all.

Much appreciated.
 
Top