NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel

NETWORKDAYS function: The function returns the number of intact working days calculated between two specific dates. Working days do not include weekends and holidays specified. Syntax: NETWORKDAYS (start_date, end_date, [holidays])

The following article introduces you to the NETWORKDAYS function - one of the functions in the date and time group function very popular in Excel.

NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 1NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 1

Description: The function returns the number of intact working days calculated between two specific dates. Working days do not include weekends and holidays specified.

Syntax: NETWORKDAYS (start_date, end_date, [holidays])

Inside:

- start_date: Start date to calculate the number of working days, is a required parameter.

- end_date: The end date to calculate the number of working days, which is a required parameter.

- holidays: Holidays need to be excluded from the working day, these days are usually not on a fixed list, is an optional parameter.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

- If any function argument is invalid -> the function returns the #VALUE! Error value

For example:

Calculate the total number of business days for the following values:

NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 2NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 2

- In the cell to calculate the total number of working days, enter the formula: = NETWORKDAYS (E7, F7, G7).

NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 3NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 3

- Press Enter -> total working days is:

NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 4NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 4

- Similarly copying the formula for the remaining prices results:

NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 5NETWORKDAYS function - The function returns the number of whole working days between 2 dates in Excel Picture 5

Here, with the same start and end dates, but since February 11, 2016 is off-company leave, the number of working days is reduced by 1.

Above are instructions and some specific examples when working with NETWORKDAYS function in Excel.

Good luck!

5 ★ | 2 Vote