Get a date n working days in the future or past
=WORKDAY.INTL(start_date, days, [weekend], [holidays])| Parameter | Description |
|---|---|
start_date |
The start date. |
days |
Working days before or after start date. |
weekend |
[optional] Setting for non-working days. |
holidays |
[optional] A list of dates that are non-working days. |
To illustrate how WORKDAY.INTL works, assume we are scheduling a task that takes 5 working days, starting on Monday, July 1, 2024. The goal is to calc
="1-Jul-2024"+5 // returns "6-Jul-2024"The result is Saturday, July 6, 2024. While this is a valid result, it doesn't take into account that Saturday is probably not a working day. If, on t
=WORKDAY.INTL("1-Jul-2024",5) // returns "8-Jul-2024"The result is Monday, July 8, 2024. This is because WORKDAY.INTL automatically skips Saturdays and Sundays when it calculates a result. Taking things
=WORKDAY.INTL("1-Jul-2024",5,"0000111") // returns "9-Jul-2024"The result is now Tuesday, July 9. The text string "0000111" means Mondays, Tuesdays, Wednesdays, and Thursdays are workdays, and Fridays, Saturdays,
=WORKDAY.INTL("1-Jul-2024",5,"0000111",{"4-Jul-2024";"2-Sep-2024"}) // returns "10-Jul-2024"The formula in D5 does not use WORKDAY.INTL and simply adds 5 days to the start date:
=B5+C5 // returns "6-Jul-2024"The formula in D6 uses the WORKDAY.INTL function but does not provide any holidays:
=WORKDAY.INTL(B6,C6)// returns "8-Jul-2024"