Menu
EXCEL WORKDAY.INTL FUNCTION
Excel WORKDAY.INTL Function Introduction
This method produces a date in working days in the future or past based on the start date and number of days specified. This function is similar to the WORKDAY function, with the exception that you can set the weekend to Friday and Saturday, Monday and Sunday, or any day or any two consecutive days of your choosing. Weekends are automatically excluded by WORKDAY.INTL (Saturday and Sunday).
WORKDAY.INTL can also take into account holidays if desired (fourth parameter). Provide a range that includes a holiday day or dates that will be considered as non-working days and will not be included in the outcome for the Holiday argument.
Description of Excel WORKDAY.INTL Function
Syntax:
=WORKDAY.INTL (start_date, days, [weekend], [holidays])
Parameter list:
- start date – the beginning date.
- days – the time limit.
- weekend – [optional] specifying which days of the week are designated weekends (weekend number given below).
- Holidays – [Optional] a list of one or more dates that should be treated as non-working days.
Step By Step Guide of WORKDAY.INTL Function
Example:
In this example, in the final computation, we provided two holiday days as the fourth parameter to omit these
dates as well as the weekend Saturday.
Key Points
- WORKDAY.INTL returns the #NUM! error if start date or start date + day or holiday is invalid.
- WORKDAY.INTL returns the #VALUE! error if weekend is not valid.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
