How to Use WORKDAY Function

The WORKDAY Function is to return a number that represents a date before or after a number of working days.

Formula:

= WORKDAY(start_date, days, [holidays])

Explanations:

  • Start_date is required, the start date.
  • Days is required. The number of nonweekend and nonholiday days before or after start_date: a positive value for a future date; a negative value for a past date.
  • Holidays is optional. An list of one or more holiday dates to exclude from the working calendar.

Cautions:

  • By default, Microsoft Excel uses January 1, 1900 as serial number 1.
  • If any argument is not a valid date, WORKDAY function returns the #VALUE! error.
  • When days are not an integer, it is truncated to an integer.

Example: To determine the day after workdays

You can also use the WORKDAY function to determine the date if you know the start date, and the working days after. For example, if the start date is 1/18/2016, and after 50 working days, the date will be 3/28/2016. If there is one holiday between, the date will be 3/29/2016.

Download: WORKDAY Function

Leave a Reply