Buzz
This article introduces the WORKDAY function, one of the commonly used functions in the date and time category in Excel.
Description: Returns a date before or after the start date based on a specified number of working days. Weekends and holidays are not counted as working days.
Syntax: WORKDAY(start_date, days, [holidays])
In this context:
- start_date: Represents the starting date, a mandatory parameter.
- days: Refers to a day that is not a weekend or holiday before or after the start_date, also a mandatory parameter.
+ days > 0 -> number of days generated in the future.
+ days < 0 -> number of days generated in the past.
- holidays: Dates to be excluded from working days; these dates do not fall on fixed holidays.
Note:
- Excel stores dates in serial numbers for convenient calculations.
- Any of the parameters is invalid -> the function returns an error value #VALUE!
- If the value of start_date + days results in an invalid date -> the function returns the error value #NUM!
- If the value of days is a decimal, it is truncated to an integer.
Example:
Calculate the date after a specified number of working days for the following tasks:
- In the cell where you want to calculate, enter the formula: =WORKDAY(F7,G7,H7).
- Press Enter -> the returned value is:
- Similarly, copy the formula for the remaining values to get the results:
- For a scenario with more than 1 day off, enter the formula: =WORKDAY(F9,G9,H9:H10).
- Press Enter -> the returned value is:
Here is the guide and some specific examples of using the WORKDAY function.
Wishing you success!
