Forum Discussion
Solved
NETWORKDAYS.INTL ERROR
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.
Do you mean that you see the formula in the cell instead of the result?
- 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.
- 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 Replies
This formula replaces the NETWORKDAYS.INT() formula
=SUMPRODUCT(N(WEEKDAY(C153+ROW(INDIRECT("1:"&D153-C153)))<>1))1=Sunday
2=Monday
3-(...)
Do you mean that you see the formula in the cell instead of the result?
- 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.
- 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.
- HansVogelaar you solved it. Thank you!
