Excel WORKDAY function

Function              WORKDAY

Description        Excel WORKDAY function number returns a date by adding or subtracting business days or working days. This function is automatically calculates Sundays and Saturdays as weekend holiday.

Syntax  WORKDAY(start_date, days, [holidays])

start_date is a date in serial number format, it represents the start date.

days is a numeric value representing the difference to be calculated from the start date. Enter a positive value to add and negative value to subtract.

[holidays] is optional, an optional range of one or more dates to exclude from the working calendar, such as national holidays and floating holidays.