Excel WORKDAY() Function

Excel WORKDAY() Function

The WORKDAY() function in excel returns the serial number of the date before or after a specified number of workdays.

Syntax

WORKDAY (START_DAY, DAYS, [HOLIDAYS])

Parameter

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

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

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

Category

Date & Time

Return

This function returns the serial number of the date before or after a specified number of workdays.

Example 1

Objective: Add 90 working days to 'Dummy Dates' 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	42496	6-May-16	=WORKDAY (B8,90, $G$14:$G$22)
20-Sep-17	43125	25-Jan-18	=WORKDAY (B9,90, $G$14:$G$22)
21-Mar-17	42941	25-Jul-17	=WORKDAY (B10,90, $G$14:$G$22)

Related Topics

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.

Dependent Drop-down List in Excel

Excel forms are used to fetch data from the end user. When we have to give choices, we often use the drop-down feature of Excel. In this tutorial, we won’t...

7 minutes read.

Goal Seek in Excel

Goal Seek in Excel The Goal Seek Excel function in Excel facilitates an automatic solving approach by adjusting a few pointers to reach a required output. Goal seeking is used when you have a value in...

3 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 COUNT() Function

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

1 minute read.

Histogram in Excel

What is Histogram in Excel? “ A histogram is a graphical tool familiar for summarizing discrete or continuous data, where the data are measured on an interval scale.” Karl Pearson described this...

5 minutes read.

Absolute Value in Excel

What is Absolute Value in Excel? Microsoft Excel worksheet is a combination of numeric values and alphabets. The numeric value is either a positive value or a negative value. Sometimes the...

5 minutes read.

Pivots Table in Excel

What is a Pivot? A pivot table is a tool to create summary reports from data-sets irrespective of their sizes but is helpful even if the data is more than just...

5 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 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.

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.

Blank cells in Excel

Microsoft Excel is spreadsheet software designed by Microsoft in 1987. It is used to perform arithmetic calculations in various fields like statistical, engineering and financial. Many times, we export data...

4 minutes read.

Excel EOMONTH() Function

Excel EOMONTH() Function The EOMONTH() function in excel returns the serial number of the last day of the month before or after a specified number of months. Syntax EOMONTH (Start_Date, Month) Parameter Start_Date(required)- This parameter...

1 minute 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.

Nearest Multiple in Excel

In Excel, the values in Multiplication can be round up, down and to nearest Multiplication number using Excel default function. This makes the calculation to be performed in an easier...

3 minutes read.

Excel EXACT() Function

The EXACT() function in excel checks whether the specified values (texts, numbers) are exactly the same or not. It returns a Boolean value TRUE if the compared values are same, else it...

1 minute read.

How to lock cells in Excel?

How to lock cells in Excel? The locked cells feature used to protect and secure your Excel sheet or workbook from the unauthorized access. If the cells are locked, it can’t be deleted, reformatted,...

5 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 ROUND() Function

Excel ROUND() Function The ROUND() function in excel rounds the numbers to specified digits. Syntax ROUND(Number,num_digits) Parameter Number(required)- This parameter represents the number which you want to round up. num_digits(required)- This parameter represents the number of decimal places to which...

1 minute read.

How to Highlight Duplicates Words in the Microsoft Excel?

We can easily highlight the values that are duplicated in the selected dataset, whether it could be a column or a row from the particular table, with the help of...

6 minutes read.