How to use the WORKDAY function in Microsoft Excel
Business days do not include weekends or any day defined as a holiday. People can use the WORKDAY function to calculate an invoice due date, expected delivery time, or the number of days the job is done.
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 days other than weekends or public holidays before or after the start date. This is also a required parameter.
- Holidays: Days to exclude 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 one.
How to use the WORKDAY function in Microsoft Excel Picture 1
First, we will calculate the first date in the table using the start_date and days only syntax .
Enter the formula =WORKDAY(A2, B2) in the cell where you want to put the result.
How to use the WORKDAY function in Microsoft Excel Picture 2
Then press the Enter key on the keyboard to see the results.
How to use the WORKDAY function in Microsoft Excel Picture 3
For the Monday in the table, for example want to exclude the next week's holiday from the working day.
So type =WORKDAY(A3, B3, F2) in the cell.
How to use the WORKDAY function in Microsoft Excel Picture 4
Then press Enter.
Other ways to use the WORKDAY function in Excel
There are two other methods to use the WORKDAY function in Excel.
How to use the WORKDAY function in Microsoft Excel Picture 5
The first method is to click the fx button at the top left of the Excel sheet.
The Insert Function dialog box will appear.
Inside the dialog box, section Select a Category , 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.
How to use the WORKDAY function in Microsoft Excel Picture 6
In the Start_date section , type in cell A3.
In the Days section , enter B3 in the box.
In the Holidays section , enter 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.
How to use the WORKDAY function in Microsoft Excel Picture 7
The Function Arguments dialog box will appear.
Follow the steps in method one for Function Arguments.
Hope you are succesful.
You should read it
- The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
- Basic Excel functions that anyone must know
- How to use the SUM function to calculate totals in Excel
- How to use Hlookup function on Excel
- Save time with these text formatting functions in Microsoft Excel
- How to use the LEN function in Excel
- How to use the WRAPROWS function in Excel
- How to use the NPER function in Excel to plan loans and savings
- How to use COUNTIF function on Excel
- How to use the IFS function in Excel 2016
- How to use the MOD function and QUOTIENT function in Excel
May be interested
What are XLSX files? How to convert XLSX files to XLS, CSV, PDF
5 free PDF converter apps for smartphones and tablets
Steps to use Outline View in Microsoft Word
Download the most beautiful Slide PowerPoint template 2021
How to view the edit history of a cell in Google Sheets
How to convert Excel to PDF keeping the formatting