NETWORKDAYS.INTL ERROR

[charitos89]

Hello.

I am facing a problem when i am using the NETWORKDAYS.INTL function. I want to count the workdays (Monday-Saturday) excluding the Sunday. So i am typing:

=NETWORKDAYS.INTL(C153;D153;11)

where C153 is the start date, D153 is the end date & 11 is the code for the specification of the weekend days for Sunday only.

Although i am not getting a result. Screenshot attached.

Please can you help me solve this problem?

Thank you.

[#2 · Accepted solution]

@charitos89 

Do you mean that you see the formula in the cell instead of the result?

1. Check whether the cell with the formula is formatted as Text. If so, format it as General. Then press F2 and Enter to recalculate it.
2. If that was not the problem, activate the Formulas tab of the ribbon. If the 'Show Formulas' button is highlighted, click it to turn it off.

[#3]

@Hans Vogelaar you solved it. Thank you!

[#4]

@charitos89 

This formula replaces the NETWORKDAYS.INT() formula

=SUMPRODUCT(N(WEEKDAY(C153+ROW(INDIRECT("1:"&D153-C153)))<>1))

 1=Sunday

2=Monday

3-(...)