WORKDAY Function

The WORKDAY function is similar to the NETWORKDAYS function.  It differs in that it calculates a date X number of days from the Start_date.  The "target" date can be either before or after the Start_date.  This function is frequently used the Start or End date for a project.

The syntax for the WORKDAY function is: =WORKDAY(Start_day, Days, Holidays)

Where:
"Start_date" = The start date of the period to be calculated
"Days" = The number of days for the period
"Holidays" = The date or range of dates to be excluded from the Period.  The "Holidays" argument is optional.


In the post for NETWORKDAYS I said that "The data could be entered into a table similar to the one here."  Actually, only the list of Holidays is typically entered in a table like this and is usually on a hidden sheet.  The "Start_date" and "Days" are entered as arguments in the formula wherever the function is being used in the workbook.


As with NETWORKDAYS the Holiday argument is optional and is not limited to holidays but can be used for any day to be excluded from the calculation.


If the function is to be used to calculate the beginning date rather than the ending date the "Days" argument is entered as a negative.