WORKDAY(S, D [, H])

 

Description

This function 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

Where B1:B2 = DATEVALUE("1/7/91"), DATEVALUE("1/8/91").

 

WORKDAY(DATE(93, 1, 1), 258, A1:A5) = 34334

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