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;D15...
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.
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!