Excel Formulas to Calculate the Working days per Month ~ Simple Tricks!!

While working with Excel, we are able to count only the workdays in any month by excluding the weekends and specified holidays. This step-by-step tutorial will assist you to calculate the total number of working days per month using the NETWORKDAYS and EOMONTH functions. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

You can use the below formula to find out the total number of working days in a month.

=NETWORKDAYS(date,EOMONTH(date,0),holidays)

Syntax Explanations:

NETWORKDAYS – In Excel, the NETWORKDAYS Function helps to return the number of working days between two dates.
EOMONTH – This function will return the last day of the month after adding/subtracting a specified number of months to a date. Read more on the EOMONTH function.
Date – It represents the input dates on your worksheet.
Holidays – It specifies the holidays on your worksheet.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

First, we will enter the input months in Column B.
Here, we are going to find out the total working days on a specified month excluding the holidays given in Column E.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Bottom-Line:

So yeah guys this is how we can calculate the total working days based on given month in Excel. If you have any questions , feel free to comment. We will assist you.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **