next up previous contents index
Next: NOMINAL Up: A. Function Reference Previous: NAND   Contents   Index


NETWORKDAYS

Syntax: NETWORKDAYS(S, E, H)

S = Starting date, a date/time value
E = Ending date, a date/time value
H = A range of dates to exclude, such as holidays

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

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'')

Excel function: N/A


next up previous contents index
Next: NOMINAL Up: A. Function Reference Previous: NAND   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003