Excel is a spreadsheet program that is developed for Windows, Mac, Android, and iOS. It helps to perform mathematical calculations on your PC. Sometimes, we want to know the future or past work days from a specific date. At that time, we can make use of the Excel WORKDAY function. It purposes to find the nearest work date based on the given start date.
This function excludes weekends and holidays if specified. Today, we will show you how to use Excel WORKDAY Function in the spreadsheet with the sample scenario and examples for your quick understanding. Get an official version of MS Excel from the following link:
- Here, you will see the syntax of the WORKDAY function.
- To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
- Once you enter the formula, click the Enter button to get the result.
=WORKDAY(start_date, days, [holidays])
- start_date – The date from which to start.
- days – It refers to the working days before or after the start_date.
- holidays – This is an optional one. A list of dates that should be considered non-work days.
What will WORKDAY Function do?
It is one of the built-in functions in Microsoft Excel. This function returns the nearest working day based on the given input date. This function can exclude the weekends and holidays if we specified them. Let’s assume that a student wants to submit a report regarding an internship before the deadline. For that, he needs to calculate the date when the internship completes including weekends and holidays.
He can take 10 working days to make a report. And he has to consider today as the first working day.
In order to find out when the work will complete, he can use the Excel WORKDAY function. Use the following formula:
=WORKDAY(start date, 5, holidays)
Once executed the formula, we will get the report completion date which is 10 working days from the given start date excluding holidays.
If the above-mentioned example doesn’t enough for you to understand this WORKDAY function, then the following are simple examples that you can take a look at. We hope that it might help.
Let’s see examples to understand how to use the WORKDAY Function in a simple manner.
- Initially, you must open your Excel workbook on your PC and launch the worksheet with data.
- For instance, we have given the input values in the range B3:C9, and we will get the output using the WORKDAY function.
- Then, you must enter the formula in the cell below to get the result.
- After entering the formula, you need to click the Enter button to get the output.
- Once you get the output for the first cell, then you need to drag down the cell to fill in the remaining values.
Thus, we have understood that the Excel WORKDAY Function helps to calculate the working days between two given dates. We have learned what is Workday or Working day generally and how to use this WORKDAY function on Excel with the help of the following sites: Working Day and WORKDAY Function.
Finally, you can understand the major purpose of the WORKDAY function in Excel with the help of sample scenarios. So that, you can easily find the future or past work date based on the given start date in your worksheet. The given examples will let you understand this function as simply as possible. To learn more about Excel functions, then visit our webpage, Aawexcel.com.
If you are curious about what others think about the WORKDAY function of Excel, then you can move to the Quora interaction webpage. This popular webpage had millions of discussions regarding several topics including Excel. From there you can get to know more about the Excel WORKDAY function. Here, we have provided the link to Quora’s official website: Excel WORKDAY Function.
The following video will show you how to use the Excel WORKDAY function in the worksheet.
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?