Networkdays function help

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

 

[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"?

 

[MattG]

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

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

Much appreciated.