The WORKDAY.INTL function takes a date and returns the nearest working in the future or past, based on an offset value you provide. Unlike the WORKDAY function, WORKDAY.INTL allows you to customize which days are considered weekends (non-working days).
Purpose of Excel WORKDAY.INTL Function
Excel WORKDAY.INTL function can be used when you want to get the date after a given number of working days.This function is best used when you want to calculate the invoice due date, project due date, delivery date, etc.
It returns the serial number of the date that is after or before the specified number of working days (from the specified start date).
=WORKDAY.INTL (start_date, days, [weekend], [holidays])
|start_date||The start date||Mandatory|
|days||The end date||Mandatory|
|weekend||Setting for which days of the week should be considered weekends||Optional|
|holidays||A list of one or more dates that should be considered non-work days||Optional|
- A Date can be entered as:
- A result from some other function.
- A date stored as text.
- A date entered as text (In double quotes).
- A Weekend could be any two consecutive days or any single day of the week.
- In case of part-time jobs or non-consecutive non-working days, type the below format in [weekend] section.
Since 2007 for Windows.
Since 2011 for Mac.