< Go Back

Excel WORKDAY Function

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.

Formula Syntax

=WORKDAY(start_date,days,[holidays])

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.

KEY TERMS

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)
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar