Get the Number of Workdays Between Two Dates in Excel

Add to Favorites

How to calculate the total number of working days between two dates in Excel.  This allows you to exclude all weekends, holidays, and any other dates that you specify.

This is an invaluable method to use when calculating payment schedules, shipping dates, and much more in Excel.

To do this we will use the NETWORKDAYS() function.

Syntax

=NETWORKDAYS(start_date, end_date, [holidays])

ArgumentDescription
Start_date

The start of the calculation.  This must be entered as a date, but, in almost all cases you will simply reference a cell that already contains a date.

End_date

The end of the calculation.  This must be entered as a date, but, in almost all cases you will simply reference a cell that already contains a date.

[Holidays] A list of holidays to exclude from the number of working days calculation.  This can be entered as an array of date serial numbers but, it's much easier to simply reference a range of cells that contain dates for the holidays, as described below.

[] means the argument is optional.

Simple Working Days Calculation

Let's find the number of working days between January 11, 2016 and March 15, 2016.

  1. Type =NETWORKDAYS( in the cell where you want to see the result.
  2. Select the starting date for the calculation.
  3. Type a comma to go to the next argument and then select the ending date for the calculation.
  4. Hit Enter and you are done.

This tells us that there are 47 working days between these two dates.  It is as simple as that.

Working Days Calculation with Holidays

You may need to account for holidays in your company when calculating the total number of working days. This is easy to do and just requires us to maintain a list of holidays that we can then reference.

Let's say that we still want to find out the total number of working days between January 11, 2016 and March 15, 2016, but now we will include some holidays in there.

  1. Create a list of holidays.  I will do this on the same worksheet so you can see everything at once but, in practice, it's best to keep this on a separate worksheet so it doesn't get messed-up.
  2. Type =NETWORKDAYS( into the desired cell.
  3. Select the starting date.
  4. Type a comma and then select the ending date.
  5. Type another comma to go to the final argument Holidays.  Then select the range of dates for your holidays.
  6. Hit enter and you're done!

You can see now that the total number of working days is three days less once we have included the dates for the holidays.

Notes

If the start_date for the NETWORKDAYS function is on a working day, it will be included in the total number of working days returned by the function; this is also true for the end_date.

This is a very helpful function to use in Excel for keeping track of work, employees, billing, and so much more.  It's very simple to use but you must make sure that your holiday dates list is properly updated every year so that you don't have issues with the final calculation.

Make sure to download the accompanying spreadsheet so you can see this function in action.


Excel Function: NETWORKDAYS()
Downloadable Files: Excel File

Similar Content on TeachExcel
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
Calculate the Difference Between Two Times in Excel
Tutorial: Here, youll learn how to get the difference between two times in Excel. A common example...
Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY
Tutorial: Use a function in Excel to get the number of the day in a week, from 1 to 7.  This allows...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY
Tutorial: How to find a date that is so many days before or after a specified date, excluding weeken...
Dates in Excel Explained
Tutorial: I'll explain how dates in Excel work and then point you to many useful tutorials on how t...