Excel Workday Function

Workday Function

Workday function returns a date, N working days in future or past and it can be used to add or subtract workdays to a given date. It calculates workday by excluding the start date. Workday function is used to calculate due dates, delivery dates, and other dates that should exclude non-working days.

Syntax

=workday(start date, days, holidays)

Arguments

• Start date- REQUIRED. Date from which working days needs to count
• Workday function excludes the start date while fetching the workday.
• Days- +ve for future working date and –ve for past working date.
• Holidays. Optional. A list of date or an array constant of the serial numbers representing the dates that should be considered as non-working days. Excel only cares about holiday dates, not holiday names.

*Date – be it a start date or a date in the holiday list- should be entered using Date Function or as result of other formula or functions. Problem can occur if date is entered as TEXT (#VALUE! Error occurs).

Points to Keep in Mind:

• If start_date plus days yields an invalid date, WORKDAY returns the #NUM! error value.
• If days is not an integer, it is truncated.

By default, workday function excludes weekends as Saturday & Sunday for fetching the workday in future or past. To customize which day(s) of the week is/ are considered as weekend, use Excel WORKDAY.INTL Function.