WORKDAY Function Explained
The WORKDAY Function in Microsoft Excel is used to calculate the date after a given number of workdays have passed. It takes two arguments: the start date and the number of workdays to add. It can also take an optional third argument, which is an array of holidays that should be excluded from the calculation. The WORKDAY Function returns the date after the given number of workdays have passed, excluding weekends and holidays.
WORKDAY Function Syntax
WORKDAY(start_date, days, [holidays])
- start_date: The start date from which you want to calculate the number of working days.
- days: The number of working days you want to add to the start date.
- holidays: (Optional) An array of dates that should not be included when calculating the number of working days.