Excel function NETWORKDAYS

Updated on Thu Jan 12 2023

SHARE

The NETWORKDAYS function in Excel is a built-in function that allows you to calculate the number of working days between two dates. It excludes weekends and holidays from the calculation, so it's useful for determining the number of days between two dates that are not weekends or holidays. For example, you can use the NETWORKDAYS function to calculate the number of days between the start and end dates of a project, or to determine how many days are left in a certain time period. The syntax for the NETWORKDAYS function is =NETWORKDAYS(start_date, end_date, [holidays]), where start_date is the start date of the time period, end_date is the end date of the time period, and [holidays] is an optional range of cells that contain a list of holidays to exclude from the calculation.

Here's how you can use the NETWORKDAYS function in Excel:

Start by entering the NETWORKDAYS function in a cell. The syntax for the NETWORKDAYS function is:

=NETWORKDAYS(start_date, end_date, [holidays])

For example, to calculate the number of working days between the dates in cells A1 and B1, you would enter the following formula in a cell:

=NETWORKDAYS(A1, B1)

The function will then calculate the number of working days between the start date and end date, excluding weekends and any holidays that you have specified.

You can also specify a range of cells that contain a list of holidays, and the NETWORKDAYS function will exclude those dates from the calculation. For example, if you have a list of holidays in cells C1:C5, you can use the following formula to exclude those dates from the calculation:

=NETWORKDAYS(A1, B1, C1:C5)

The function will then return the number of working days between the start and end dates, excluding weekends and the holidays specified in the holiday range.

The NETWORKDAYS function is a simple and convenient way to calculate the number of working days between two dates in Excel. Give it a try and see how it can help you with your date calculations.

SHARE