WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE

[BLOTTY]

I CREATED A WORKSHEET WHICH TAKES A GIVEN DATE, SUBTRACTS A NUMBER OF GIVEN
DAYS AND A STANDARD NUMBER OF DAYS TO OUTPUT AN EARLIER DATE (NOT INCLUDING
WEEKENDS) WHEN OTHERS TRY TO USE IT ON DIFFERENT PC'S, SOME GET A "#NAME?"
ERROR AND WHILE OTHERS IT WORKS FOR.

THE FORMULA I USED IS:

=WORKDAY(B4,-C4-3)
B4=01/01/07 (DATE FORMAT 3/14/01)
C4=1 (NUMBER FORMAT 0 DECIMAL PLACES)

 

[Bob Phillips]

It is part of the Analysis Toolpak. It sounds that some have it installed,
some don't. Get them to check (Tools>Addins)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Ron Coderre]

Per Excel Help:

Evidently, some of your co-workers have the ATP add-in active and some don't.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[BLOTTY]

Thanks fellas, that was it. Should I tell my IT department to turn on all
these add-ins or could this cause problems???

 

[Gord Dibben]

Blot

Please do not use all caps. Hard to read and is considered "SHOUTING"

The Analysis ToolPak add-in has to be loaded through Tools>Add-ins to prevent
the #NAME? error.

If you check out Help on WORKDAY function it will tell you that.


Gord Dibben MS Excel MVP

 

[Bob Phillips]

No, don't do that. Just the Analysis Toolpak will be fine in 90% of
situations.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[BLOTTY]

Ok, thanks

No, don't do that. Just the Analysis Toolpak will be fine in 90% of
situations.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[BLOTTY]

Sorry about the caps. This was my first day using this avenue for help.
Thanks again.

 

[Gord Dibben]

Apologies accepted and explanation is reasonable and understandable with a
newcomer.

Welcome to the world of news groups, especially the Excel news groups.

Gord

Sorry about the caps. This was my first day using this avenue for help.
Thanks again.

Gord Dibben MS Excel MVP

 

[K]

I have a question. I had every one on my team install the add ins and it
works fine until one of them filters the data by the auto filters set up then
all of the formulas containing workdays/networkdays give a #Name? error.

 

[Bob Phillips]

Can you give more detail. I was unable to reproduce it as far as I
understood.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)