Back to Class Index
WORKDAY(S, D[, H])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. Parameters 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 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") |