Networkdays returning a #name error

[Nick Graham]

I have the following formula

NETWORKDAYS($F12,$I12,Holidays)

In some rows it works but in others it returns a #NAME error. The name error will disappear it I click into the formula box and hit return. Does anyone know why this is happening?

I am running Windows XP and Excell 2002

 

[TheNoocH]

is HOLIDAYS in your formula a named range containing a list of the holidays you want excluded?

 

[Nick Graham]

Yes, the range is SLA!$E$1:$M$1, SLA is a separate sheet in the same workbook.

 

[TheNoocH]

i can't get it to duplicate...
is it possible that you have manual calc on? that's the only other idea esp if when you click and hit enter the #NAME goes away

 

[Mark W.]

You need to add the Analysis ToolPak. NETWORKDAYS is supplied by that addin.

 

[just_jon]

That function requires the Analysis ToolPak be nstalled [ Tools | Addins | check Analysis ToolPak ].

 

[Mark W.]

See the Excel Help topic for "Correct a #NAME? error".

 

[Nick Graham]

Thanks, the analysis pack was already installed. Running through all the suggestions in the Help seems to have fixed it even though these were things that had already been done.