Excel Function : WORKDAY

Download now!

Excel Function : WORKDAY

Category

Date and time

Description

Returns the serial number of the date before or after a specified number of workdays

Microsoft Excel Reference Page

https://support.office.com/en-us/article/WORKDAY-function-f764a5b7-05fc-4494-9486-60d494efbf33

Syntax and Description of the WORKDAY Excel Function

The WORKDAY function syntax is as follows: WORKDAY(start_date, days, [holidays]) start_date is the start date for the calculation. days is the number of days you want to add to the start date, excluding weekends and holidays. holidays is an optional list of dates to exclude from the calculation.

About WORKDAY Excel Function

The WORKDAY function returns a date that is the indicated number of workdays before or after a given start date. WORKDAY(start_date, days, [holidays]) The start_date argument is a date that represents the start date. The days argument is the number of workdays before or after the start date. A positive value for days yields a future date; a negative value yields a past date. The holidays argument is an optional list of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. If the start_date is not a workday, WORKDAY adjusts the return date to the next workday.