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!
With GIMP, often jokingly referred to as the free version of Photoshop, users can easily remove objects in the background of images with just a few tools. This technique requires a little patience to get the best results.
FC Mobile Code contains many rewards such as FC Point, player package, diamond package... Below we have compiled the latest FC Mobile giftcodes along with how to redeem codes to receive rewards.
AFK Journey Code will help players have a smoother and easier start in their journey.
Code Xsamkok Super Energy Three Kingdoms gives players a series of rewards when exchanging codes.
Convert numbers to words in Excel, convert amounts to words with Excel versions from 2003 to 2016, Excel is free like WPS Office, no need to install add-ins, supports both 32-bit and 64-bit versions.
What is the percentage function in Google Sheets? How to calculate percentage in Google Sheets? Let's find out with Quantrimang.com!
Autodesk AutoCAD 2020 has a free download program for those who are students, students or teachers with copyrighted software. Users only need to use the confirmation document and that's it.
The idea behind Samsung's system-wide internal search feature is to help users find everything they need on their device from a single area, with simple, quick operations.
When you turn this feature off, only registered accounts can use your Chromebook. It's super simple to do.
Mufasa: The Lion King has officially premiered worldwide. Is Mufasa: The Lion King worth your money to see in theaters?
Should you embed or link to a video in PowerPoint? If you are wondering the same thing, this article will give you the answer.
To create a recognizable and successful brand, you need to invest in brand management. Here's everything you need to know about brand management.
Adding your own handwriting or artwork to your videos instantly makes them more personal and authentic. With Final Cut Pro on iPad, it's easier than ever.
Depending on each person's needs, we can hide albums on Facebook, or hide photo posts on Facebook. After you hide all photos on Facebook, others cannot see those photos.
You may know that Android phones can open two apps at once in Split Screen view. This is one of many Android features that can help you stay productive.
