NETWORKDAYS 1

[RayW158]

I am using Excel 2010 for the first time. I have used the function NETWORKDAYS in the past with Excel 2001 but I am recieving a #VALUE! error in my result. I also tried the NETWORKDAYS.INTL function and with it I recieved the #NUM! error. Below are the specifics, any ideas on why I am getting the errors?

CELL E5 CELL F5 FORMULA RESULT
4/30/2012 4/1/2012 #NUM!
the formula =NETWORKDAYS.INTL(E5:F5:1:0)

#VALUE!
the formula =NETWORKDAYS(E5:F5:5)

Also, in the formulas, 2010 is using : where I am used to using , is this of any concern?

 

[SkipVought]

did you try SEMICOLON rather than COLON?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[RayW158]

Skip,

I tried Semicolons instead of Colons as you suggested. Excel 2010 considered this an error in the formula and changed them back to colons.

Ray

 

[Gruuuu]

they should ALL be commas. There should be no multiple cell ranges.

 

[RayW158]

Gruuuu,

This is the exact formula as prepared by Excel 2010.

=NETWORKDAYS.INTL(M9:N9:0:0)

I thought comma's were used also but 2010 will not accept commas and it wants to use the colons. This is true of all formulas.

The above formula givesa #NUM! error.

Ray

 

[Gruuuu]

I'm using Excel 2010 and it works for me (if I change the formula to be correct)

tangential note: Why are you using 0 for the "weekend" value? 0 isn't a valid option. In order for Net Work Days to make sense, some days should be excluded as Non-Work days

according to the help file:
[tt]
Weekend number Weekend days
1 or omitted Saturday, Sunday
2 Sunday, Monday
3 Monday, Tuesday
4 Tuesday, Wednesday
5 Wednesday, Thursday
6 Thursday, Friday
7 Friday, Saturday
11 Sunday only
12 Monday only
13 Tuesday only
14 Wednesday only
15 Thursday only
16 Friday only
17 Saturday only
[/tt]

 

[1726]

The source of your problem may lie in the Region and Language settings of your PC

In Windows 7:

Open Control Panel
Open Region and Language
From the 'Formats' tab click the 'Additional Settings' button

In here check the setting for List Separator

If it is a Colon ) change it to a Comma (,)

Beware that this may have knock on effects with other applications on your PC