The following:
=IF(OR($E15="",$Q15=""),"",IF(NETWORKDAYS($Q15,$E1 5,Holidays)<=2,"Met","Missed"))

=IF(AND($E15<"",$C15<"",$A15<"R"),IF(LEFT($C15, 2)="CM",WORKDAY($E15,9,Holidays),WORKDAY($E15,4,Ho lidays)),"")

=IF(OR($E15="",$K15="",$L15=""),"",IF(AND(LEFT($C1 5,2)<"CM",LEFT($C15,2)="RA",NETWORKDAYS($E15,$L15 ,Holidays)<=5),"Met",IF(AND(LEFT($C15,2)="CM",NETW ORKDAYS($E15,$L15,Holidays)<=10),"Met","Missed")))

Please keep in mind these formulas are working fine on everybody elses
computers!


"Fred Smith" wrote:

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.