masud8956
Board Regular
 Joined
 Oct 22, 2016
 Messages
 163
 Office Version

 2016
 2011
 2007
 Platform

 Windows
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.
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
Code:
=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
Last edited: