- 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 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.
- 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.
|10/1/2012||Start date of project|
|3/1/2013||End date of project|
|=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|