If you’re like most people, you probably use Microsoft Excel to keep track of your workdays. But how do you calculate the number of workdays in a month or year? There’s a handy function for that! The WORKDAYS() function calculates the number of days in a given period. To use it, just type the following into your Excel spreadsheet: WORKDAYS(date) For example, if you want to find out how many days are in February, you would type: WORKDAYS(2/1/2015) ..
With Microsoft Excel’s NETWORKDAYS function, you can count the number of workdays that fall between two specified dates. This function excludes Saturdays, Sundays, and optionally the specified holidays. We’ll show you how to use it.
This function can account for holidays in its calculation, but you must specify those holidays in a column, so be ready with a list of your holiday dates. Also, it’s important you keep in mind that this function counts both the starting date and the ending date in the calculation.
RELATED: Use Excel to Calculate How Many Days Until an Event
Find the Workdays Between Two Dates in Excel
To get the number of workdays that fall between two dates, first, open your spreadsheet with Microsoft Excel.
In your spreadsheet, click the cell where you want to display the resulting workday number.
In the selected cell, type the following function and press Enter. In the function, replace B2 with the cell that contains the starting date and C2 with the cell containing the ending date.
Excel will calculate the number of workdays between your dates and display the result in the selected cell. Note that this number includes both the starting date and the ending date.
If you’d like to exclude any holidays from your calculation, then first, specify your holidays in a column. Like so:
Click the cell where you want to get the result, type the following function, and press Enter. In this function, replace B2 with the cell that contains the starting date, C2 with the cell that contains the ending date, and E2:E6 with the range where you’ve specified your holidays.
Excel will display the result in your selected cell. Note that this count excludes your specified holidays but includes the starting and the ending date.
And that’s how you can use an Excel function to quickly find the number of days someone has worked between any two dates. Very useful!
Do you want to find the number of full days between two dates in Excel? If so, there’s a quick way to do that.
RELATED: How to Find the Number of Days Between Two Dates in Microsoft Excel
