=NETWORKDAYS not working as expected and as it once did

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is that I can NOT get the function =NETWORKDAYS to operate!

I had a workbook with a worksheet in it with data from the previous year
working well with this function. I copied, then renamed the workbook, opened
the relevant worksheet and the function yields the error #NAME?

I have installed the Analysis Toolpack AND the Analysis Toolpack VBA but it
still does not work! FAQ indicated that there should be a list of functions
in the Data drop-down after installing this toolpack but there isn’t!

I tried FAQ and – on the off chance that the dates entered were not in the
=DATE format as suggested – changed the dates as required and still got the
same result!

Sample data that yields this error:

A B C D E
1 11/6/06 29/6/06 12/6/06 #NAME?

Where columns B, C, and D contain the date entered in the format
=DATE(2006,6,11), =DATE(2006,6,29) and =DATE(2006,6,12).

Column E has the function:

IF(OR(ISBLANK($B1),ISBLANK($C1)),â€â€,IF(ISBLANK($D1),NETWORKDAYS($B1,$C1),NETWORKDAYS($B1,$C1,$D1)))

Any ideas on why this function will not yield the days as it once did?
 
Your formula contains non-standard quotes. Replace them with the standard
double-quotes
 
Back
Top