WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 
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
 
Thanks fellas, that was it. Should I tell my IT department to turn on all
these add-ins or could this cause problems???
 
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
 
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)
 
Ok, thanks

Bob Phillips said:
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)
Click to expand...
 
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.
Click to expand...

Gord Dibben MS Excel MVP
 
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.
 
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)
 
Back
Top