WORKDAY.INTL()
Syntax. WORKDAY.INTL()(start_date,days,weekend,holidays)
Definition. This function returns the serial number of the date before or after an indicated number of workdays and allows the weekend days to be defined.
Arguments
start_date (required). The date that represents the start of 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 returns a past date.
weekend (optional). A number or string indicating which days are weekends and should not be treated as workdays.
holidays (optional). An array of one or more dates for work-free days to exclude from the working calendar, such as federal holidays ...
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.