WORKDAY()
Note
In Excel 2003, this function is available as an add-in.
Syntax. WORKDAY(start_date,days,holidays)
Definition. This function returns the serial number of the date before or after an indicated number of workdays.
Arguments
start_date (required). The start date for the calculation.
days (required). The number of nonweekend and nonholiday days (workdays) before or after the start date. A positive value for the days returns a future date and a negative value a past date.
holidays (optional). An array of one or more dates for work-free days to exclude from the working calendar, such as federal holidays and floating holidays.
Background. You might want to calculate a payment date based on a delivery time, or you might need to know the date 20 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.