Problem with NETWORKDAY.INTL Function

[masud8956]

I have used the formula below several times in my worksheet. I am using Excel 2016 so not facing any problem. But some other users are getting errors who are using Excel 2007/2010.

=IF($K$7="","",IF(NETWORKDAYS.INTL($K$7,$E$8,7,$T$35:$V$67)<1,"-",NETWORKDAYS.INTL($K$7,$E$8,7,$T$35:$V$67)))

When I delete the ".INTL" portion of the formula in Excel 2010, I get the result 1 day more probably because of the default holidays.

Is there any way around to be able to get the same result as NETWORKDAYS.INTL compatible for Excel versions as old as 2007? Weekly holidays are meant to be FRI and SAT for my case.

Thanks

 

[jasonb75]

When I replied earlier, I misread the last line of your post as 'half day off' instead of '1 or 2 days off'.

In hindsight, I think that this is correct

=WORKDAY($E$8+1,$F$19/$B$23,IF($D$16:$D$48<>"",$D$16:$D$48+1,))

 

[masud8956]

Thank you. Works fine!!