| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS calculation returns inconsistent results
I'm using NETWORKDAYS in a scheduling spreadsheet to calculate the
number of working days between two date columns. The first column (C) records the date a task was created, the second (E) when the task is scheduled to be completed. If the lead time (the difference between these dates) is less than 3 working days, I want to flag the fact. The calculation IF(NETWORKDAYS(C258,E258)<3,"x","") works most of the time, but occasionally there are instances whe a) there are actually 3 clear working days between the dates but the above formula returns "x" and b) there are less than 3 clear working days between the dates but the above formula does NOT return "x" Am I missing some subtlety of the function here? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MOREFUNC.XLL - RECALL() to trigger once only calculation? | Excel Discussion (Misc queries) | |||
| Calculation on SUMIF Results | Excel Worksheet Functions | |||
| Equity buildup calculation | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| returns calculation using sumproduct | Excel Worksheet Functions | |||
Threaded Mode
