Forum Discussion
charitos89
Sep 13, 2021Copper Contributor
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...
- Sep 13, 2021
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
Sep 13, 2021MVP
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.
charitos89
Sep 13, 2021Copper Contributor
HansVogelaar you solved it. Thank you!