Hi,

I'm after a correct function using the IF and also the NETWORKDAYS.INTL functions

I have the following

=IF($F$5="YES",NETWORKDAYS.INTL($B$5,$B$6,"0111111",Sheet2!$F$4:$F$27)/2,(NETWORKDAYS.INTL($B$5,$B$6,"0111111",Sheet2!$F$4:$F$27)/2)-(NETWORKDAYS.INTL($B$5,$B$6,"0111111",Sheet2!$N$4:$N$27)/2))

So what i want this code is tell me is if F5 is Yes i want it to just take information dates on sheet2 between F4 and F27 on Sheet1 but if No i also want it to take into account the dates between N4 and N27 as well as those between F4 and F27

Thanks