Logo
×

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

AutoFill in Excel

AutoFill in Excel Excel is known for its credibility to operate repeated and similar tasks automatically. For this purpose, it facilitates an inbuilt feature known as Autofill that recognizes the series of...

3 minutes read.

Excel OFFSET () Function

Excel OFFSET () Function The OFFSET() function in excel returns range of cells that is a specified number of rows and columns from an initial specified range. Syntax OFFSET (reference, rows, cols, [height], [width]) Parameter reference(required)-...

2 minutes read.

Copying formula in Excel

Copy a formula in Excel While working with statistical calculations in Microsoft Excel, the user uses formulas to calculate the mathematical operations. Implementing these formulas manually for each data is a...

3 minutes read.

Check Marks in Excel

What is a Check Mark? Among various characters checkmark is one of the characters used to indicate that the item or product in the list is correct, chosen or selected. A...

5 minutes read.

Calculating the Last Day of the Month in Excel

In Microsoft Excel, various functions exist to calculate the date and time from the current date to the past and future. Among multiple tasks in this tutorial, let's see how...

3 minutes read.

Purpose of Randomize in Excel

Excel spreadsheets are used on a large scale for business and personal usage. It is used to store data, perform multiple calculations, make assumptions based on charts and graphs etc....

7 minutes 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 create drop down in excel?

How to create drop down in excel? Drop-down lists are mostly used to facilitate data entry operations. They are commonly used in interactive websites or applications. Microsoft has expanded his Excel's data validation feature...

5 minutes read.

Excel File using Password

How to Protect an Excel File using Password? Nowadays Microsoft Excel is widely used by large organizations to small organizations for their personal and professional usage. They share files to various...

2 minutes read.

Converting Units in Excel

The numeric values present in Excel consist of various types such as constant, integer, decimal etc. For calculation purposes, the values present in the data need to be converted to...

4 minutes read.

Sum Every Nth Row in Microsoft Excel

The main and the critical use of the SUM Function is used to add all the amounts of the numerical data and thus efficiently produce the sum of all at...

3 minutes read.

Excel SMALL() Function

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

1 minute read.

Excel VALUE() Function

The VALUE() function in excel converts the specific text representing a number (i.e., a number, date, or time format) into a numerical value. Syntax VALUE(Text) Parameter Text(required)- This parameter represents the string that you want...

1 minute read.

Excel MIN() Function

Excel MIN() Function The MIN() function in excel returns the smallest or minimum value from the provided numbers, named range or array. It ignores logical values and text. Syntax MIN(Number1,Number2, ...) Parameter Number1(required)- This parameter represents the...

1 minute read.

Excel RIGHT() Function

The RIGHT() function in excel returns the rightmost characters from a text value. This function is used for data manipulation. Syntax RIGHT(Text, [num_chars]) Parameter Text (required)- This parameter represents the string from which you want to find...

1 minute read.

Locate Maximum Values in Excel

Excel is a combination of numeric values and numbers. To retrieve the result, Excel provides various formulas and functions. Sometimes the user needs to find the largest value from the...

5 minutes read.

Excel SUBSTITUTE() Function

The SUBSTITUTE() function in excel substitutes/replaces the old text with the new text in a string. SUBSTITUTE function is used to clean data. This function is case-sensitive. Syntax SUBSTITUTE(Text, Old_Text, New_Text, [instance_number]) Parameter Text (required)- This...

2 minutes read.

Calculating Age in Excel

Microsoft Excel provides separate functions for various mathematical operations. Nowadays, Microsoft Excel is widely used by large and various organizations. Using formulas one can calculate the statistical functions quickly and...

2 minutes read.

How to Delete Row in Microsoft Excel?

Individuals can quickly delete the respective row from the particular Microsoft Excel whenever they want, according to their needs and requirements. In this tutorial, we will discuss the following things in...

7 minutes read.

How to generate random numbers in Excel

In this tutorial, we will discuss the following things in detail that are as follows: Introduction about Random Numbers used in Microsoft Excel. Discuss how to generate the Random Numbers in Microsoft...

6 minutes read.