| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel NETWORKDAYS - incorrect results
Why does NETWORKDAYS add 1 to positive results and subtracts 1 from negative
results? Please see example below: Agreed Date Actual Date Variance Calculated Should be (Bus Days) 31/08/2004 13/08/2004 13 12 31/08/2004 28/09/2004 -21 -20 Does anyone know how to get around this? I have tried the IF function, to no avail. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Goalseek gives incorrect results | New Users to Excel | |||
| results incorrect | Excel Discussion (Misc queries) | |||
| vlookup gives incorrect results | Excel Worksheet Functions | |||
| Very large workbook now giving incorrect results :( | Excel Discussion (Misc queries) | |||
| Grouping the results of Networkdays | Excel Discussion (Misc queries) | |||
![Patricia[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
