WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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

--
HTH

Bob Phillips

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

"BLOTTY" wrote in message
...
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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

Per Excel Help:

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.<<

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

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

XL2002, WinXP


"BLOTTY" wrote:

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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

"BLOTTY" wrote:

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

Blot

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

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

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


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 15:31:01 -0700, BLOTTY
wrote:

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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

"BLOTTY" wrote:

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

Ok, thanks

"Bob Phillips" wrote:

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

"BLOTTY" wrote:

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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

"Gord Dibben" wrote:

Blot

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

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

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


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 15:31:01 -0700, BLOTTY
wrote:

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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

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

Gord

On Wed, 12 Jul 2006 16:31:02 -0700, BLOTTY
wrote:

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

"Gord Dibben" wrote:

Blot

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

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

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


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 15:31:01 -0700, BLOTTY
wrote:

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)



Gord Dibben MS Excel MVP

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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" wrote:

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

"BLOTTY" wrote:

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)

WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE
 

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)

"K" wrote in message
...
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" wrote:

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

"BLOTTY" wrote:

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)