NETWORKDAYS calculation returns inconsistent results

  • Thread starter Thread starter Analowl
  • Start date Start date
A

Analowl

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 where:
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?
 
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 where:
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?
Click to expand...

Post some examples of the data you are using, the actual results, and the
expected results.
--ron
 
Back
Top