Excel Formulas to Find the Remaining Working Days in a Month!!

Assume that you have a list of dates, and you need to calculate the remaining working days in that month. How can you calculate them quickly? Today, I will introduce some quick tricks to achieve them in Excel. Let’s jump into this article!! 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 left over working days on a certain month in Excel.

*=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 dates in Column B.
Here, we are going to find out the remaining 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.

Verdict:

In this guide, we have described the quick and easy way to calculate the remaining working days of a certain month in Excel. I hope this helps. Feel free to ask back any questions and let us know how it goes. I will keep working with you until it’s resolved.

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