HomeTechnologyNewsHow to calculate working days with a function in Microsoft Excel

# How to calculate working days with a function in Microsoft Excel

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 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)`

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.

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

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)`

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

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

Stay Connected
16,985Fans
2,458Followers
61,453Subscribers

Related News