Excel > Functions

NETWORKDAYS Function

The Excel NETWORKDAYS function returns the number of workdays between two dates. NETWORKDAYS excludes weekends and dates recognised as a holiday.

The syntax for the NETWORKDAYS function is:

=NETWORKDAYS(start_date, end_date, [holidays])

Argument

Purpose

Start_date

The start date

End_date

The end date

Holidays

An optional list of dates to exclude from normal working days. This is usually entered as a range of cells

The examples below demonstrate the NETWORKDAYS function being used to calculate the number of workdays between two dates.

Data to be used for the Excel NETWORKDAYS function

Function

Result

=NETWORKDAYS(A2,B2)

41

=NETWORKDAYS(A2,B2,D2:D4)

38

Follow us on

Facebook  Twitter  You Tube 

Other Date & Time Functions

Excel 2010 Superhero Course