NETWORKDAYS

[Guest]

I am trying to use the networkdays function but I get a #NAME error!
I have loaded analysis function but it still does not work

Regards Steve

 

[Guest]

That error is typical of not having analysis-toolpak isntalled. There are
two very similar ones to install, analysis toolpak & analysis toolpak VBA.
Check that you have the right one installed. Tools -> Addins. If not then
I'm stumped, works for me...

 

[Bob Phillips]

You are not trying to use a non-defined range name within the formula
perchance?