Working days left in month

Many times, we need to find working days left in a month. This can be found by using the NETWORKDAYS function in Excel. This tutorial will show you how to use the function.

NETWORKDAYS function

NETWORKDAYS is a function which returns the number of working days between starting and the ending dates. It’s an inbuilt function of Excel.

Syntax

=NETWORKDAYS(start_date,end_date,[holidays])

In order to calculate the leftover workdays of the month, you can use the NETWORKDAYS function which would make your task much easier. The function itself excludes all the weekends and holidays from a custom list.

Illustration

Figure 1. The example of NETWORKDAYS function

For instance, in the example given above,

The formula in cell C2 is:

=NETWORKDAYS (A2,B2,(A5:A6))

In this case, A2 contains the current date or the starting date. B2 contains the ending date and A5:A6 is a range of holidays.

Combination of NETWORKDAYS and EOMONTH functions

To account for the change in last day i.e 31st Jan in case of January and 30th in case of April, you can either provide the final date yourself or use EOMONTH function that itself finds the last day of the month.

Generic formula

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

So, this was the tutorial on finding working days left in a month. We hope that this was helpful to you and you may not face any problem with this in the future.

Notes

The NETWORKDAYS.INTL function

When we are working with the custom weekends which are basically considered as the working days, it would be more convenient for us to use the NETWORKDAYS.INTL function. It automatically excludes the weekends and calculates the working dates that have been provided by the user.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar