Formulas and Functions

Chapter 3 Date and Time Functions 61
WORKDAY
The WORKDAY function returns the date that is the given number of working days
before or after a given date. Working days exclude weekends and any other dates
specically excluded.
WORKDAY(date, work-days, exclude-dates)
 date: The date the function should use. date is a date/time value. The time portion
is ignored by this function.
 work-days: The number of working days before or after the given date. work-days
is a number value. It is positive if the desired date is after date and negative if the
desired date is before date.
 exclude-dates: An optional collection of dates that should be excluded from the
count. exclude-dates is a collection containing date/time values.
Example
=WORKDAY(”11/01/2009”, 20, {”11/11/2009”,”11/26/2009”}) returns Dec 1, 2009, the work day 20 days
after 11/01/2009 excluding weekends and the two holidays specically excluded.
Related Topics
For related functions and additional information, see:
“NETWORKDAYS” on page 54
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41