| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NAME? Error
I have a spreadsheet that I sent to a collegeau who is having difficulty with
one of the formulas. The formula is returning the #NAME? error in the cell. However when she sent the spreadsheet to me the formula works correctly. Here's the formula: =NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(J1),1),DATE( YEAR(TODAY()),MONTH(J1)+1,0))-J10-J11-J12 The formula is used to determine the number of available shipping days in a month minus planned shutdown days, etc. Why does the formula work on one computer and not the other??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Threaded Mode
