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