Calling all experts! IF, AND, and NETWORKDAYS FUNCTION.

[jwang776]

Hi Everyone,

Thanks for taking the time to look at my conundrum. I'm having trouble with the following formula:

=IFERROR(If(and((NETWORKDAYS($C2,$D2,0)>5,networkdays($c2,$d2,0)<=10),1,0),0))

I have a date entered in column C2 as: 8/1/2017
I have a date entered in column D2 as: 7/17/2017

This will yield a negative answer for networkdays($C2,$D2,0) which is fine.

The formula in bold above is located in column F2, which yield a 1 if the network days are greater than 5 but less than or equal to 10 and a 0 if it is outside these parameters.

Any help would be greatly appreciated! Thanks!

 

[JoeMo]

Try:

=IFERROR(IF(AND(NETWORKDAYS($C2,$D2,0)>5,NETWORKDAYS($C2,$D2,0)<=10),1,0),0)

 

[jwang776]

Try:

=IFERROR(IF(AND(NETWORKDAYS($C2,$D2,0)>5,NETWORKDAYS($C2,$D2,0)<=10),1,0),0)

Thanks Joe! Can't believe I made such a careless mistake. Appreciate the help