It returns the date that is the given number of days before or after the starting date. Weekends and holidays are excluded.
The syntax of the function is the following:
WORKDAY(start_date, days, [holidays])
start_date: The start date from which we want to start the calculation.
days: The number of working days before (negative number) or after (positive number) the start_date.
[holidays]: Optional. A range of dates that are defined as holidays and excluded from the calculation.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the WORKDAY function:
Use the proper formula in the cell I2 to produce the date which appears in the cell A2 with an addition of 5 more working days.