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?

--
MattG

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









In article <[email protected]>,
"MattG" <[email protected]> wrote:

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

[MattG]

JE McGimpsey wrote:

> 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.

--
MattG