This function excludes Saturdays, Sundays, and optionally the specified holidays.

We’ll show you how to use it.

In your spreadsheet, nudge the cell where you want to display the resulting workday number.

Select a cell to display the NETWORKDAYS result.

In the selected cell, jot down the following function and press Enter.

In the function, replaceB2with the cell that contains the starting date andC2with the cell containing the ending date.

Excel will calculate the number of workdays between your dates and display the result in the selected cell.

Type the NETWORKDAYS function.

Note that this number includes both the starting date and the ending date.

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.

The result of the NETWORKDAYS function.

Do you want tofind 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

Enter the holidays in a column.

Use NETWORKDAYS with holidays.

NETWORKDAYS' result with holidays.