[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

WORKDAY

Syntax:

WORKDAY ( start-date , day-offset [ , holidays ] )

Description: Computes the serial value of the date that is day-offset working days offset from start-date. Weekend days and any holidays specified by holidays are not considered as working days.

Arguments:

Name

Type

Description

start-date

number

The start date, truncated to integer.

day-offset

number

The number of working days before or after start-date. A positive value yields a future date; a negative value yields a past date; a zero value yields the date start-date. day-offset is truncated to an integer.

holidays

reference, array

An optional set of one or more dates that are to be excluded from the working day calendar. holidays shall be a range of cells that contain the dates, or an array constant of the serial values that represent those dates. The ordering of dates or serial values in holidays can be arbitrary.

 

Return Type and Value: number – The serial value of the date that is day-offset working days offset from start-date, excluding the specified holidays.

However, if

start-date is out of range for the current date base value, #NUM! is returned.

Any date in holidays is out of range for the current date base value, #NUM! is returned.

start-date plus day-offset yields an invalid date, #NUM! is returned.

[Example:

WORKDAY(DATE(2006,1,1),0) results in a serial value corresponding to 1-Jan-2006
WORKDAY(DATE(2006,1,1),10) results in a serial value corresponding to 13-Jan-2006
WORKDAY(DATE(2006,1,1),-10) results in a serial value corresponding to 19-Dec-2005
WORKDAY(DATE(2006,1,1),20,{"2006/1/2","2006/1/16"}) results in a serial value corresponding to 31-Jan-2006

end example]