next up previous contents index
Next: XIRR Up: A Function Reference Previous: WEEKDAY

WORKDAY

 

Syntax: @WORKDAY(S, D[, H])

S = Serial start date value
D = Number of days before (negative) or after (positive) start date
H = Cell or range of cells containing serial date values to exclude

@WORKDAY returns the serial day value that is D working days after day S (if D is positive) or D working days before day S (if D is negative), excluding weekends and all holidays specified as dates in range H.

Examples:

@WORKDAY(@DATE(91, 1, 1), 5, B1..B2) = 33249 or 01/11/91,
where A1..A2 =
@DATEVALUE(``1/7/91''),
@DATEVALUE(``1/8/91'')

@WORKDAY(@DATE(93, 1, 1), 258, A1..A5) = 34334 (or 12/31/91),
where A1..A5 =
@DATEVALUE(``1/1/93''),
@DATEVALUE(``5/25/93''),
@DATEVALUE(``7/4/93''),
@DATEVALUE(``9/3/93''),
@DATEVALUE(``11/28/93'')


next up previous contents index
Next: XIRR Up: A Function Reference Previous: WEEKDAY

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999