Note that WORKDAY.INTL willautomaticallyexclude Saturdays and Sundays but will only exclude holidays if they are provided.
The goal is to calculate a date that is 5 working days after July 1, 2024.
This is because WORKDAY.INTL automatically skips Saturdays and Sundays when it calculates a result.
Note: the holidays above are provided as anarray constantbut more typically holidays are provided as a range.
Remember that holidays must be valid Excel dates.
The name of the holiday is not used at all byWORKDAY.INTL.
Of course, in real life, you will not hardcode dates into formulas like this.
You will instead use cell references.
The screen below shows the four formulas above “ported” to a workbook with cell references.
The weekend argument
What makes WORKDAY.INTL different from the original WORKDAY function is theweekendargument.
Whereas the WORKDAY function is hardcoded to treat Saturday and Sunday as weekend (i.e.
There are two ways to configure the weekend argument:
Let’s look at both approaches.
See thetable belowfor the full list of available codes.
This text string can contain only 1s and 0s.
Note: weekend must be entered as a text string surrounded by double quotes (i.e.
“0000011”) when using this feature.
When calculating a result, WORKDAY.INTL excludes dates that are Sundays and dates that are holidays.
Visualized Example
It can be hard to visualize how WORKDAY.INTL works when it calculates a result.
The second formula (G6) excludes weekend daysandholidays and returns January 2, 2025.
The shading and highlighting are applied withconditional formatting.
For a full explanation with details,see this page.
Example - is this date a workday?
One problem you might run into is how to test a date to determine whether it is a workday.
you’re able to use WORKDAY.INTL for this task, but the formula is not immediately obvious.
you’re free to see this approach in the worksheet below.
NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.
…
NETWORKDAYS.INTL Function
The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates.
