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:
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.
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!
Travel planning used to mean folders full of printed confirmations, handwritten notes, guidebooks, and a slightly terrifying number of browser tabs. Now, pretty much everything you need for a trip can live on the device already in your pocket.
Record heat has lifted air-conditioning demand while gas-market shocks have returned volatility to power prices. That creates a real risk of painful bills—but not a guaranteed, Europe-wide price explosion.
Large format printing has long faced criticism for its environmental impact. Traditional substrates, solvent-based inks, and short-lived promotional campaigns have all contributed to the perception that eye-catching graphics come at a high environmental cost.
Long-distance travel can involve heavy traffic, changing weather conditions, and rider fatigue. If you are also dealing with the responsibilities of moving home, such as packing belongings or coordinating accommodation, a long ride may add unnecessary pressure to an already busy schedule.
Tired of Microsoft Teams shortcut error preventing you from opening the app? Follow our expert, step-by-step guide with the latest fixes for instant resolution. Works on Windows, Mac & web – no tech skills needed!
Tired of Microsoft Teams Task Management Sync Error halting your workflow? Follow our proven, step-by-step fixes to resolve sync issues fast and restore seamless task collaboration. No tech expertise needed!
Struggling with Microsoft Teams Wiki Error Formatting? This step-by-step guide reveals proven fixes for common wiki tab issues, ensuring smooth editing and collaboration in Teams. Get back to productive wikis fast!
Struggling with Microsoft Teams installation error on Linux? Discover step-by-step fixes for Ubuntu, Fedora & more. Resolve dependency issues, crashes, and errors quickly with our ultimate guide. Get Teams running smoothly today!
Struggling with Microsoft Teams "Error Page" not loading? Get step-by-step fixes for desktop, web, and mobile. Solve Microsoft Teams Error Page issues quickly and resume seamless teamwork today.
Tired of Microsoft Teams "Error Screenshot" blocking your workflow? Get proven, step-by-step solutions to resolve screenshot errors in Teams instantly and boost productivity. No tech skills needed!
