{"id":1014,"date":"2019-05-02T14:01:19","date_gmt":"2019-05-02T11:01:19","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=1014"},"modified":"2019-05-02T14:01:23","modified_gmt":"2019-05-02T11:01:23","slug":"the-workday-intl-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-workday-intl-function\/","title":{"rendered":"The WORKDAY.INTL Function"},"content":{"rendered":"\n

It returns the date that is the given number of days before or after the starting date. Weekends and holidays are excluded. The difference with the WORKDAY <\/a><\/strong>function is that it allows custom weekend days.<\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

WORKDAY.INTL<\/strong>(start_date, days, [weekend], [holidays]<\/strong><\/em>) <\/p>start_date<\/strong>: The start date from which we want to start the calculation.
days<\/strong>: The number of working days before (negative number) or after (positive number) the start_date.
[weekend]<\/strong>: Optional. A number that indicates which days of the week are part of the weekend. Default is 1.
[holidays]<\/strong>: Optional. A range of dates that are defined as holidays and excluded from the calculation. <\/cite><\/blockquote>\n\n\n\n
weekend<\/strong><\/td>Weekend days<\/strong><\/td><\/tr>
1<\/td>Saturday, Sunday<\/td><\/tr>
2<\/td>Sunday, Monday<\/td><\/tr>
3<\/td>Monday, Tuesday<\/td><\/tr>
4<\/td>Tuesday, Wednesday <\/td><\/tr>
5<\/td>Wednesday, Thursday <\/td><\/tr>
6<\/td>Thursday, Friday<\/td><\/tr>
7<\/td>Friday, Saturday<\/td><\/tr>
11<\/td>Sunday<\/td><\/tr>
12<\/td>Monday<\/td><\/tr>
13<\/td>Tuesday<\/td><\/tr>
14<\/td>Wednesday <\/td><\/tr>
15<\/td>Thursday<\/td><\/tr>
16<\/td>Friday<\/td><\/tr>
17<\/td>Saturday<\/td><\/tr><\/tbody><\/table>\n\n\n\n
<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here is an example of how to use the WORKDAY.INTL function:<\/strong><\/p>\n\n\n\n

Use the proper formula in the cell I2 to produce the date which appears in the cell A2 with an addition of 5 more working days.
\nMake sure the formula will consider only Sundays as non-working days.<\/p>\n\n\n\n

\n