Exceljet

Quick, clean, and to the point

Excel NETWORKDAYS Function

Excel NETWORKDAYS function
Summary 

The Excel NETWORKDAYS function calculates the number of working days between two dates. NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates. 

Purpose 
Get the number of working days between two dates
Return value 
A number representing days.
Syntax 
=NETWORKDAYS (start_date, end_date, [holidays])
Arguments 
  • start_date - The start date.
  • end_date - The end date.
  • holidays - [optional] A list of non-work days as dates.
Usage notes 

The NETWORKDAYS function counts the number of working days (business days) between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays. For example, with a start date in A1 and end date in B1:

=NETWORKDAYS(A1,B1) // will exclude weekends

The NETWORKDAYS function can also exclude holidays supplied as a list of dates. For example, with holiday dates in C1:C5:

=NETWORKDAYS(A1,B1,C1:C5) // exclude weekends and holidays

NETWORKDAYS can be used to calculate employee benefits that accrue based on days worked, the number of working days available during a project, the number of working days required to resolve a customer support issue, and so on.

Notes:

  1. NETWORKDAYS calculates whole work days, ignoring any time values.

  2. NETWORKDAYS will automatically exclude both Saturday and Sunday. If you have a custom weekend schedule, see the NETWORKDAYS.INTL function.

  3. NETWORKDAYS includes both the start date and end date when calculating work days. This means if you give NETWORKDAYS the same date for start date and end date, it will return 1.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.