The WORKDAY function takes three arguments: start_date, days, and holidays. Start_date must be a valid Excel date. The days argument is the number of days in the future or past to calculate a workday. Use a positive number for days to calculate future dates, and a negative number for past dates. Holidays is an optional argument to specify non-working days. Holidays should be provided as a range that contains valid Excel dates. If holidays are not provided, WORKDAY will treat only Saturdays and Sundays as non-working days. When calculating a result, WORKDAY does not include the start date as a work day.
Example #1 - Basic usage
In the formula below, WORKDAY is given Friday, January 1, 2021 for start_date, 1 for days, and F5:F13 for holidays. The result is Monday, January 4, 2021 since Saturday and Sunday are excluded: If the start date is moved back one day to Thursday, December 31, 2021, the result is the same, since January 1 is a holiday, and Saturday and Sunday are also excluded:
Example #2 - worksheet as shown
In the worksheet shown above, Column B contains a variety of different start dates, column C contains the number of days to move, and “holidays” are the named range F5:F13. The formula in column D (copied down) is: At each row, WORKDAY returns the nearest workday in column D, based on the given start date and days to offset.
Weekends
By default, WORKDAY will exclude weekends (Saturday and Sunday) . If you need to customize which days of the week are considered weekend days, use the more robust WORKDAY.INTL function.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
