How to calculate working days with a function in Microsoft Excel

0
338

[ad_1]

With Microsoft Excel NETWORKDAYS function, you can count the number of working days that fall between two specified dates. This feature excludes Saturdays, Sundays, and optionally specified holidays. We will show you how to use it.

This function can take holidays into account in its calculation, but you must specify those holidays in a column, so have a list of your holiday dates ready. Also, it is important to note that this function counts both the start date and the end date in the calculation.

RELATED: Use Excel to calculate how many days are left until an event

Find the working days between two dates in Excel

To get the number of business days between two dates, first open your spreadsheet in Microsoft Excel.

In your spreadsheet, click the cell where you want to display the resulting business day number.

Select a cell to display the result NETWORKDAYS.

In the selected cell, type the following function and press Enter. In the function, replace B2 with the cell containing the start date and C2 with the cell containing the end date.

=NETWORKDAYS(B2,C2)

Write the function WORKDAYS.

Excel will calculate the number of business days between your dates and display the result in the selected cell. Note that this number includes both the start date and the end date.

The result of the NETWORKDAYS function.

If you want to exclude holidays from your calculation, first specify your holidays in a column. Like:

Enter the holidays in a column.

Click in the cell where you want to get the result, type the following function and press Enter. In this function, replace B2 with the cell containing the start date, C2 with the cell containing the end date, and E2:E6 with the range where you have specified your holidays.

=NETWORKDAYS(B2,C2,E2:E6)

Use NETWORKDAYS with holidays.

Excel will display the result in the selected cell. Note that this count excludes the specified holidays, but includes the start and end date.

NETWORKDAYS 'result with holidays.

And that’s how you can use an Excel function to quickly find the number of days someone has worked between two dates. Very useful!


Do you want to find the number of whole days between two dates in Excel? If so, there is a quick way to do it.

RELATED: How to find the number of days between two dates in Microsoft Excel

[ad_2]