WORKDAY(start_date, days, list_holidays)

The WORKDAY function returns a date that is start_date plus or minus days - a specified number of workdays, taking into account weekends and holidays given by list_holidays.

For example, the formula

WORKDAY("February/1/97", 100, "March/28/97")

returns the date "June/23/1997", a date 100 workdays after 1st Feb 97, given a holiday on 28th March.

See also:

Other date functions