tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft

Excel Functions

(Scroll to see more)

Share this page:

MS Excel: NETWORKDAYS Function (WS)

Learn how to use the Excel NETWORKDAYS function with syntax and examples.

Description

The Microsoft Excel NETWORKDAYS function returns the number of "work days" between 2 dates, excluding weekends and holidays.

Syntax

The syntax for the Microsoft Excel NETWORKDAYS function is:

NETWORKDAYS( start_date, end_date, [holidays] )

Parameters or Arguments

start_date is the start date to use in the calculation. It must be entered using the DATE function.

end_date is the end date to use in the calculation. It must be entered using the DATE function.

holidays is optional. It is the list of holidays to exclude from the "work days" calculation. It can be entered either as a range of cells that contain the holiday dates (ie: E2:E4) or as a list of serial numbers that represent the holiday dates.

Applies To

The NETWORKDAYS function can be used in the following versions of Microsoft Excel:

  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007

Type of Excel Function

The NETWORKDAYS function can be used in Microsoft Excel as the following type of function:

  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel NETWORKDAYS function examples and explore how to use the NETWORKDAYS function as a worksheet function in Microsoft Excel:

Microsoft Excel

Based on the spreadsheet above, the following Excel NETWORKDAYS examples would return:

=NETWORKDAYS(A2,B2) would return 10
=NETWORKDAYS(A2,B2,E4) would return 9
(because it would exclude Easter Monday which is stored in cell E4)
=NETWORKDAYS(A2,B2,DATE(2013,4,1)) would also return 9
(because it would exclude Easter Monday which is equal to the DATE(2013,4,1) formula)
=NETWORKDAYS(A2,B2,E2:E4) would return 8
(because it would exclude Good Friday and Easter Monday)
=NETWORKDAYS(A3,B3) would return 5
=NETWORKDAYS(A3,B3,E2:E4) would return 4
(because it would exclude Easter Monday)
=NETWORKDAYS(DATE(2013,3,24),DATE(2013,4,6)) would return 10