View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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)