Kornilios Ampatzis/ May 2, 2019/ Functions

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:

Practice

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.

Share this Post