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!
Struggling with Microsoft Teams 'Undefined Error' (2026)? Discover proven, step-by-step fixes like clearing cache, updating the app, and more. Get back to seamless collaboration fast!
Discover simple, step-by-step methods to disable Microsoft Teams at startup and unlock better PC performance. Faster boot times, less resource drain—perfect for Windows users seeking smooth operation.
Stuck with Microsoft Teams "Network Error" offline? Discover proven, step-by-step solutions to fix Microsoft Teams network error offline quickly. Get back online fast—no tech skills needed!
Struggling with Microsoft Teams Error 4oggx? Discover proven fixes to resolve sign-in failures, crashes, and connectivity issues fast. Get back to productive calls without frustration!
Encountering the frustrating Microsoft Teams "Remove Account" Data Error? Discover quick, reliable fixes like clearing cache, resetting the app, and more to get back to seamless collaboration without losing data. Updated with the latest solutions.
Tired of the frustrating Microsoft Teams "Layout Error" Sidebar? Follow our proven, step-by-step troubleshooting guide with the latest fixes to get your Teams sidebar working smoothly again. No tech skills needed!
Stuck with Microsoft Teams offline error in 2026? Discover proven troubleshooting steps, common causes, and quick fixes to restore your connection fast. No tech skills required!
Tired of Microsoft Teams crashing with "Error M" memory issues? Follow our step-by-step guide to fix Error M in Teams, clear cache, update software, and boost performance—no tech skills required!
Discover the easiest step-by-step guide to setting up Microsoft Teams Town Hall events. Host massive virtual gatherings effortlessly with pro tips for seamless execution. Perfect for leaders and organizers!
Struggling with Microsoft Teams "Download Error" on PC? Discover proven, step-by-step fixes to resolve download failed issues quickly. Get back to seamless collaboration in minutes—no tech skills needed!
Stuck with Microsoft Teams "Error L" License error? Follow this step-by-step troubleshooting guide to resolve licensing issues quickly, restore access, and boost productivity without IT hassle. Updated with latest fixes.
Tired of Microsoft Teams video call freezing mid-meeting? Follow this proven troubleshooting Microsoft Teams video call freezing guide with quick fixes, advanced tips, and real solutions to restore smooth video instantly.
Frustrated by Microsoft Teams 'Download Failed Due to Unexpected Error'? Discover proven, step-by-step solutions to fix this common issue quickly and get back to seamless collaboration. Updated with the latest fixes for peak performance.
Frustrated because your Microsoft Teams recording failed? Uncover the top common reasons like permissions issues, storage limits, and network glitches, plus step-by-step fixes to prevent future failures and record flawlessly every time.
Struggling with Microsoft Teams "Error B" connection? Discover step-by-step fixes for smooth connectivity. Clear cache, check networks, and more in this ultimate guide to resolving Error B instantly.
