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