How to Use Excel NETWORKDAYS Function (Examples + Video)

Excel NETWORKDAYS Function (Examples + Video)

EXCEL NETWORKDAYS FUNCTION

When to use Excel NETWORKDAYS Function

Excel NETWORKDAYS function can be used when you want to get the number of working days between two given dates. It does not count the weekends between the specified dates (by default the weekend is Saturday and Sunday). It can also exclude any specified holidays.

A typical situation where you can use this function is to calculate the benefits accrued to employees overtime.

What it Returns

It returns a positive integer that represents the total number of working days between two specified dates.

Syntax

=NETWORKDAYS(start_date, end_date, [holidays])

Input Arguments

  • start_date – a date value that represents the start date.
  • end_date – a date value that represents the end date.
  • [holidays] – (Optional) It is a range of dates that are excluded from the calculation. For example, these could be national/public holidays. This could be entered as a reference to a range of cells that contains the dates, or could be an array of serial numbers that represent the dates.

Additional Notes

  • Saturday and Sunday are considered as weekends by default and are not counted. In case you want the weekends to be days other than Saturday and Sunday, use the NETWORKDAYS.INTL function.
  • A date can be entered as:
    • A result from some other function.
    • A date stored as text.
    • A date entered as text (in double quotes).
  • NETWORKDAYS function returns the #VALUE! error if any of the arguments is not valid.
  • This function is a part of the Analysis Tool Pack (ATP) and not Excel in-built functions. Hence, in case you get a #NAME! error, it could be due to not having the ATP or it not being loaded properly. Iu such case, try reloading the ATP.

Excel NETWORKDAYS Function – Examples

Example #1: Calculating the number of days between two dates (excluding weekends)

Excel Networkdays Function - Example 1

In the above example, the Excel NETWORKDAYS function calculates the number of days between 20th December and 10 January. It only excludes the weekends (Saturdays and Sundays) and returns 15 as the result.

In this case, we have specified no holidays, so only weekends are excluded.

Example #2: Calculating the number of days between two dates (excluding weekends and Holidays)

Excel Networkdays Function - Example 2

In the above example, the Excel NETWORKDAYS function calculates the number of days between 20th December and 10 January. It excludes the weekends (Saturdays and Sundays) and the specified holidays. The result is 13 days.

In this case, we have specified 2 days as holidays, and these are not counted while calculating the total number of working days. Note that these two holidays occur on a weekday (both 25th Dec 2015 and 01 Jan 2016 occur on a Friday). In case a holiday occurs on a weekend, it is not counted as an exclusion (as weekends are anyway not counted).

In the above example, if you change 01 Jan 2016 (which is a Friday) to 02 Jan 2016 (which is a Saturday), the result would change to 14.

Excel NETWORKDAYS Function – Video

Related Excel Functions:

You May Also Like the Following Excel Tutorials:

  • Milind

    well explained