January 28, 2023
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…

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.

=NETWORKDAYS(B2,C2)


Read Full Article Source

Leave a Reply

Your email address will not be published. Required fields are marked *