A summary of the NETWORKDAYS Function

  • Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.

This article walks you through a summary of the NETWORKDAYS function in Microsoft Excel outlining its formula syntax and usage.

NETWORKDAYS Function Description

Returns the number of full working days between start_date and end_date. Working days discount weekends and any dates confirmed in holidays. Use NETWORKDAYS to calculate employee benefits that accumulate according to the number of days worked during a particular term.

Tip: To calculate entire workdays between two dates by using parameters to represent which and how many days are weekend days, use the NETWORKDAYS.INTL function.

NETWORKDAYS function example.
© Exceljet, 2020.

NETWORKDAYS Function Syntax

NETWORKDAYS(start_date, end_date, [holidays])

The NETWORKDAYS function syntax contains the following arguments:

  • Start_date  –  Required. A date that indicates the start date.
  • End_date  –  Required. A date that symbolises the end date.
  • Holidays –   Optional. An optional range of one or further dates to exclude from the working calendar, like state and federal holidays and floating holidays. The list can be either a cell range including the dates or an array constant of the serial numbers that represent the dates.

Important: Dates should be typed by using the DATE function, or as outcomes of their formulas or functions. For instance, use DATE(2012,5,23) for the 23rd day of May, 2012. Problems can arise if dates are inputted as text.

Remarks

  • Microsoft Excel occupies dates as sequential serial numbers so they can be used in calculations. Intuitively, January 1, 1900 is serial number 1, and January 1, 2012 is serial number 40909 because it is 40,909 days after January 1, 1900.
  • If any argument is an invalid date, NETWORKDAYS returns the #VALUE! error value.

Example – a summary of NETWORKDAYS Function

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to display results, choose them, press F2, and then press Enter. If you must, you can modify the column widths to view all the data.

DateDescription
10/1/2012Start date of project
3/1/2013End date of project
11/22/2012Holiday
12/4/2012Holiday
1/21/2013Holiday
FormulaDescriptionResult
=NETWORKDAYS(A2,A3)Number of workdays between the start (10/1/2012) and end date (3/1/2013).110
=NETWORKDAYS(A2,A3,A4)Number of workdays between the start (10/1/2012) and end date (3/1/2013), with the 11/22/2012 holiday as a non-working day.109
=NETWORKDAYS(A2,A3,A4:A6)Number of workdays between the start (10/1/2012) and end date (3/1/2013), with the three holidays as non-working days.107

Top of Page

Also Look at

Time & Date

WEEKDAY Function

Leave a Reply

%d bloggers like this: