The month itself is controlled by the 2nd argument.

Since in this case we want to stay in the same month, we use zero.

If you need more control over which days are treated as weekends, use theNETWORKDAYS.INTLfunction.

Excel formula: Get workdays between dates

NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.

NETWORKDAYS.INTL Function

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates.

Use a positive value for months to move forward in time, and a negative number…

Excel formula: Working days in year

Excel NETWORKDAYS function

Excel NETWORKDAYS.INTL function

Excel EOMONTH function