Excel WORKDAY.INTL() Function

Excel WORKDAY.INTL() Function

The WORKDAY.INTL() function in excel returns a date before or after a specified number of workdays with custom weekend parameter.

Syntax

WORKDAY.INTL (START_DAY, DAYS,[WEEKEND],[HOLIDAYS])

Parameter

START_DAY (required)- This parameter represents the initial date from which you have to start calculating the working days.

DAYS(required)- This parameter represents the date end.

WEEKEND(optional)- This Setting for which days of the week should be considered weekends. The options are as follows:

1 signifies Saturday, Sunday

2 signifies Sunday, Monday

3 signifies Monday, Tuesday

4 signifies Tuesday, Wednesday

5 signifies Wednesday, Thursday

6 signifies Thursday, Friday

7 signifies Friday, Saturday

11 signifies Sunday only

12 signifies Monday only

13 signifies Tuesday only

14 signifies Wednesday only

15 signifies Thursday only

16 signifies Friday only

17 signifies Saturday only

HOLIDAY (optional)- This parameter represents a list of one or more dates that should be considered non-work days.

Category

Date & Time

Return

This function returns a date before or after a specified number of workdays with a custom weekend parameter.

Example 1

Objective: Add 90 working days to 'Dummy Dates' where weekends are Thursday and Friday and return in the result cell

Holidays	Date
New Year's Day	1-Jan-18
Republic Day	26-Jan-18
Good Friday	14-Apr-18
Idul Fitr	26-Jun-18
Independence Day	15-Aug-18
Vijaya Dashmi	30-Sep-18
Gandhi Jayanti	2-Oct-18
Deepawali	18-Oct-18
Christmas Day	25-Dec-18

Dummy Dates	Days/Answer	Date/Formatted Value	Formula Used
1-Jan-16	42494	4-May-16	=WORKDAY.INTL (B8,90, 6, $G$14:$G$22)
20-Sep-17	43127	27-Jan-18	=WORKDAY.INTL (B9,90,6, $G$14:$G$22)
21-Mar-17	42941	25-Jul-17	=WORKDAY.INTL (B10,90, 6, $G$14:$G$22)

Related Topics

Excel WEEKNUM() Function

The WEEKNUM() function in excel returns the week number from 1 to 54 of a specific date in a year. The WEEKNUM function starts counting with the week that contains January 1...

1 minute read.

Quarter Dates in Excel

Excel is a combination of numeric values and alphabets. The user's project consists of the date depending upon their accounting and financial analysis. Sometimes there is a need to find...

4 minutes read.

How to use Index and Match in Excel?

The Index and Match function is a familiar and frequently used function in Excel. It is one of the most powerful functions and is easy to use. By default, Excel...

6 minutes read.

Excel MOD() Function

Excel MOD() Function The MOD() function in excel returns the remainder after a number is divided by a divisor Syntax MOD(number, divisor) Parameter Number(required)- This parameter represents the number which you want to divide. Divisor(required)- This parameter represents...

1 minute read.

Excel Axes

What is Excel Axes? Axes are a horizontal or vertical line containing units of measure. There are two types of axes X and Y axes. X is a horizontal and Y...

3 minutes read.

Excel IFNA Function

Excel IFNA Function The IFNA in Excel is used to remove the #N/A type of errors in excel values cells with our choice of value. IFNA function is from Excel 2013 onwards, so it...

1 minute read.

Excel MID() Function

The MID() function in excel is used to return a specific number of characters from a text string starting at the position you specify. One can change the start of the string, thus...

1 minute read.

SUM Functions in Excel

The BODMAS formula plays a vital role in the concept of mathematics. BODMAS rule follows the Bracket of Division, Multiplication, Addition and Subtraction. This rule is followed for a correct...

6 minutes read.

Operators in Excel

In MS Excel, operators are used to defining the operation you want to perform on the used elements or between variables. There are four types of operators: Arithmetic operators, Comparison...

4 minutes read.

How to import Microsoft Access data into the Microsoft Excel

Microsoft Access is primarily considered vital and the primary tool for individuals who want to create and manage the respective type of Database efficiently. This tutorial will discuss how to import...

5 minutes read.

Excel INDEX () Function

Excel INDEX () Function The INDEX() function in excel returns a value from a list of tables based on the intersection of a row and a column position. This function is used with the...

2 minutes read.

Excel LARGE() Function

The LARGE() function in excel returns the k-th largest value in a data set. Syntax LARGE (Array, kth small number from the list) Parameter Array (required)- This parameter represents the list of numbers from which nth...

1 minute read.

Dependent Combo box in Excel VBA

Adding the particular dependent box in the created User form with the help of the Microsoft Excel VBA is considered essential and crucial in Microsoft Excel. Here, in this tutorial, we...

7 minutes read.

How to apply Data Protection to the Worksheet?

What do we mean by Data Protection? Data Protection in excel involves in protecting your file/data from some other user and also prevents the following accidents – Accidentally deleting or changing the formulas in...

3 minutes read.

Excel HLOOKUP() Function

Excel HLOOKUP() Function The HLOOKUP() function in excel is used to search a value in the topmost row of a table and then return a corresponding value in the same column for the specified...

2 minutes read.

Gauge Chart in Excel

A Gauge Chart in Microsoft Excel is considered the meter type chart of a group dial chart, which is eventually similar to the speedometer that has the pointer towards the...

7 minutes read.

How to make use of the Wildcard in Excel

In this modern world, it is known that the wildcard characters in Microsoft Excel are considered to be the most essential and unrated features of Microsoft Excel. Besides all these,...

8 minutes read.

What if Analysis Data Table in Excel

What is What-If Analysis? Suppose you have a cell A15 which is formula driven i.e. has a formula and the formula is based on values in different cells (A1, A2, A3, A4), what-if...

4 minutes read.

Excel MINUTE() Function

Excel MINUTE() Function The MINUTE() function in excel converts a serial number to minute (0 - 59). Syntax MINUTE (SERIAL_NUMBER) Parameter SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract...

1 minute read.

Excel COUNTBLANK() Function

Excel COUNTBLANK() Function The COUNTBLANK() function in excel counts the number of blank cells within a range. Syntax COUNTBLANK ([value1], [value [2], ...) Parameter value1(required)- This parameter represents the first cell in the range. value2, …(optional)- It represents...

1 minute read.