The Excel Workday function calculates a date that is a given number of working days (except for weekends and holidays) ahead of a particular start date. You can employ WORKDAY function to exempt the weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed. This article describes the formula syntax and usage of the WORKDAY function in Microsoft Excel.
How to use the Excel WORKDAY Function
The WORKDAY function figures out a date that represents the “nearest” working day N days in the past or future. WORKDAY can be used to calculate due dates, delivery dates, and other dates that should exclude non-working days.
If you are employing the WORKDAY in Excel, you will be required to input the following key terms.
- start date – The date you want to begin with.
- days – The range of work days ahead of or behind the start date.
- holidays – [optional] Certain dates that should be seen as work-free. They can either be a range of cells having the dates you want to exempt from your calculations, or a range constant of the serial numbers depicting the dates.
- return value- A serial number representing a particular date in Excel.
Let’s say you are working on a project containing a number of tasks. You are aware of the starting date and the number of workdays required to complete each of the tasks. You now want Excel to determine the date to complete each task. You cannot just include the start date and the total number of days because that would mean that weekends and holidays have been included to the required number of days for the tasks to get done. You will need to exclude weekends and holidays from the equation.
As soon as Excel determines the finish date, you would want a simple way to depict the project timeline. The end result should look like this.
Figure 1. Example 1. of WORKDAY function.
Now that you are familiar with the simple basic stuff, let us teach you how you can employ the WORKDAY function in your Excel sheet.
To determine workdays in Excel, you have to follow the simple steps listed below;
- Create a table in your Excel sheet and adjust it to suit your needs
- The table should include columns representing corresponding start date, days, results and holidays
- Enter a positive digit for days to return future dates and a negative digit for previous dates
- WORKDAY will exclude the start date as a work day when it returns the end date
- WORKDAY will exclude weekends by default (Saturdays & Sundays)