Forum Discussion

charitos89's avatar
charitos89
Copper Contributor
Sep 13, 2021
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...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Sep 13, 2021

    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.
Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Sep 13, 2021

charitos89 

This formula replaces the NETWORKDAYS.INT() formula

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

 1=Sunday

2=Monday

3-(...)

Resources