Sep 13 2021 12:00 AM
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.
Sep 13 2021 12:27 AM
SolutionDo you mean that you see the formula in the cell instead of the result?
Sep 13 2021 06:37 AM
This formula replaces the NETWORKDAYS.INT() formula
=SUMPRODUCT(N(WEEKDAY(C153+ROW(INDIRECT("1:"&D153-C153)))<>1))
1=Sunday
2=Monday
3-(...)
Sep 13 2021 12:27 AM
SolutionDo you mean that you see the formula in the cell instead of the result?