View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Workdays/Networkdays #Name? Error

OK. What's the formula which is giving the #Name? error?

Regards,
Fred.

"K" wrote in message
...
It's already installed.

"Fred Smith" wrote:

In Help on Networkdays, you will find that the Analysis Toolpak needs to
be
installed for it to work.

Install this addon, and your #Name?s will disappear.

Regards,
Fred.

"K" wrote in message
...
I have a question. I have a couple of columns using nested if
statements
with workdays and networkdays function.

Everything works fine on my computer, but when one of my team member
recently opened it on their comp, the columns were calculating fine
until
they autofiltered a column upon which they got the #Name? error and
then
even
when they unfilter it does not go back.

I had every one on my team install the add ins for the toolpack etc.