WORKDAY

Returns the date which is the specified number of work days before or after another specified date.

Syntax

WORKDAY( Date date, Integer offset, [ReferenceOrArray holidays], [ReferenceOrArray weekends] ) → Date

Parameters

date

Required. The date to offset.

offset

Required. The number of work days to offset.

holidays

Optional. A list of dates, that specifying the holiday dates that should not be considered work days.

weekends

Optional. A list of logical values that specify which days of the week are working days.

Remarks

This function returns the date, which is the specified amount of work days before or after date. If offset is negative, WORKDAY returns a past date; if offset is positive, WORKDAY returns a future date. If holidays is specified, it can be an array or a cell reference, containing dates or serial numbers of dates, that should be regarded as nonworking days. If weekends is specified, it can be an array or a cell reference, containing logical values. The length of weekends must be exactly 7; otherwise, the function will return #VALUE!. Each value in weekends indicates whether the corresponding day of the week (1 to 7 for Sunday through Saturday) should be regarded as a weekend. TRUE indicates a weekend, FALSE indicates a working day. If weekends is omitted, Saturday and Sunday are counted as weekends.

Example

Formula

=WORKDAY(TODAY(),10)

See Also

Function Reference
EDATE Function
EOMONTH Function
NOW Function