WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE

BLOTTY · 07-12-2006, 06:35 PM

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)

Ron Coderre · 07-12-2006, 06:55 PM

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)
>

Bob Phillips · 07-12-2006, 06:55 PM

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)

"BLOTTY" <[email protected]> wrote in message
news:[email protected]...
> 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)
>

BLOTTY · 07-12-2006, 07:05 PM

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)
>

Gord Dibben · 07-12-2006, 07:10 PM

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

On Wed, 12 Jul 2006 15:31:01 -0700, BLOTTY <[email protected]>
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)

Bob Phillips · 07-12-2006, 07:15 PM

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" <[email protected]> wrote in message
news:[email protected]...
> 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)
> >

BLOTTY · 07-12-2006, 07:35 PM

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
> > >
>
>
>

BLOTTY · 07-12-2006, 07:35 PM

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 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
>
> On Wed, 12 Jul 2006 15:31:01 -0700, BLOTTY <[email protected]>
> 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 · 07-12-2006, 08:05 PM

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 <[email protected]>
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 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
>>
>> On Wed, 12 Jul 2006 15:31:01 -0700, BLOTTY <[email protected]>
>> 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