NETWORKDAYS.INTL in 2007

Hi all,

I am using Excel 2007. I try to use this NETWORKDAYS.INTL function in my cell but it keeps showing #NAME? error. How to solve the problem?

Could you pls show us one of your formulas with NETWORKINGDAYS.INTL or, even better, a workbook example?

Please refer below. Is 2007 support fuction networkdays.intl? I read some web saying that this function only support 2010 and above.

That's true, only works for Excel 2010 onwards, missed that. Have you tried NETWORKINGDAYS (but without the optional weekend parameter) like, =NETWORKDAYS(A2,B2)

What do you need more specifically?

Hi Berlan,

Thanks for the confirmation. Yes, i tried networkdays. Reason i want to use .intl is to exclude the weekend(only sunday). Do you know any other function to calculate number of working days in a month that will exclude weekend(Sunday) and holidays. Here my weekend only Sunday.

For example in January 2015. Number of working days is 26 days. =31 calendar day - 4 sunday - 1 public holiday.