35
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

- You can use the below formula to find out the total number of working days in a month.
=NETWORKDAYS(date,EOMONTH(date,0),holidays)
- 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.
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.

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 *!! **
35