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

What Does It Do?

Use this function to calculate a past or future date based on a starting date and a specified number of days. The function excludes weekends and holidays and can therefore be used to calculate delivery dates or invoice dates.

Syntax

=WORKDAY(StartDate,Days,Holidays)

Formatting

The result will normally be shown as a number which can be formatted to a normal date by using Format,Cells,Number,Date.

Example:

The following example shows how the function can be used to calculate delivery dates based upon an initial Order Date and estimated Delivery Days.