Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any File Auto Save Function for Excel and Word 2007 (Bet | Excel Worksheet Functions | |||
Function To Dynamically Display File Size | Excel Worksheet Functions | |||
Filling Text from Another File | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions |