NETWORKDAYS(S, E, H)

 

Description

This function returns the number of working days, beginning with S and ending with E, excluding days in H and weekends.

 

Parameters

 

S

Starting date, a datetime value.

 

E

Ending date, a datetime value.

 

H

A range of dates to exclude, such as holidays.

 

Examples

 

NETWORKDAYS(DATE(93, 1, 1), DATE(93, 12, 31)) = 261

 

NETWORKDAYS(DATE(93, 1, 1), DATE(93, 12, 31), A1:A5) = 258

Where A1:A5 = DATEVALUE("1/1/93"),DATEVALUE("5/25/93"), DATEVALUE("7/4/93"), DATEVALUE("9/3/93"), DATEVALUE("11/28/93").