How to use the WORKDAY function in Microsoft Excel

In Microsoft Excel , the WORKDAY function is a date and time function that returns the date before and after a specified number of business days. Business days do not include weekends or any days that are designated as holidays. People can use the WORKDAY function to calculate invoice due dates, estimated delivery times, or the number of days a job will take.

What is the formula and syntax for the WORKDAY function in Excel?

The formula for the WORKDAY function is:

WORKDAY(start_date, days, [holidays])

The syntax for the WORKDAY function is explained as follows:

• Start_date: Start date. This is a required parameter.
• Days: The number of non-weekend or non-holiday days before or after the start date. This is also a required parameter.
• Holidays: Days to be excluded from the work schedule, such as national holidays.

How to use the WORKDAY function in Excel

To use the WORKDAY function in Excel, follow the steps below:

Launch Microsoft Excel.

Create a table or use an existing table.

First, we will calculate the first day in the table using the syntax with only start_date and days.

Enter the formula =WORKDAY(A2, B2) in the cell where you want the result to be placed.

Then press Enter key on your keyboard to see the result.

For the second day in the table, for example you want to exclude holidays next week from working days.

So, type =WORKDAY(A3, B3, F2) into the cell.

Then press Enter.

• How to use the TRUNC function in Excel

Other ways to use the WORKDAY function in Excel

There are two other methods to use the WORKDAY function in Excel.

The first method is to click the fx button at the top left of the Excel worksheet.

The Insert Function dialog box appears.

Inside the dialog box, in the Select a Category section , select Date and Time from the list box.

In the Select a Function section , select the WORKDAY function from the list.

Then click OK.

The Function Arguments dialog box opens.

In the Start_date field , enter in cell A3.

In the Days section , enter B3 in the box.

In the Holidays section , type F2 in the box.

Then click OK to see the results.

Another method is to click the Formulas tab and click the Date and Time button in the Function Library group.

In the list, select WORKDAY.

The Function Arguments dialog box appears.

Follow the steps in method one for Function Arguments.

Good luck!