Home Work How to Use a Function in Microsoft Excel to Calculate Workdays

How to Use a Function in Microsoft Excel to Calculate Workdays

by Kevin

Introduction

The NETWORKDAYS function in Microsoft Excel may count the number of workdays that fall between two dates. Saturdays, Sundays, and optionally the stated holidays are excluded from this function. We’ll demonstrate how to utilize it.

This method may take into consideration holidays in its calculations, but you must provide those holidays in a column, so have a list of your holiday dates available. It’s also worth noting that this function takes into account both the starting and ending dates in its calculations.

In Excel, find the number of working days between two dates

To calculate the number of workdays between two dates, first open your spreadsheet in Microsoft Excel.

Click the cell in your spreadsheet where you want the resulting workday number to appear.

Select a cell to display the NETWORKDAYS result.

Type the following function into the chosen cell and hit Enter. Replace B2 in the function with the cell holding the starting date and C2 with the cell containing the ending date.

=NETWORKDAYS(B2,C2)

Type the NETWORKDAYS function.

The number of workdays between your dates will be calculated by Excel and displayed in the specified cell. It should be noted that this figure includes both the beginning and ending dates.

The result of the NETWORKDAYS function.

If you want to omit any holidays from your computation, first list them in a column. As an example:

Enter the holidays in a column.

Click the cell where you want the result, then enter the following function. Replace B2 with the cell containing the starting date, C2 with the cell containing the ending date, and E2:E6 with the range where you’ve set your vacations in this function.

=NETWORKDAYS(B2,C2,E2:E6)

Use NETWORKDAYS with holidays.

Excel will display the result in the cell you’ve chosen. This count excludes your stated holidays but includes the start and finish dates.

NETWORKDAYS' result with holidays.

That’s how you may use an Excel formula to rapidly determine how many days someone worked between any two dates. Very helpful!

You may also like

Navhow is dedicated to teaching people all over the world how to do anything.

 

Subscribe

The Best How-To Newsletter Anywhere

©2022 Navhow, All Right Reserved