Go Back

Get workdays between dates

Read time: 25 minutes

In this tutorial, you will learn how to get workdays between dates. This is possible by using Excel NETWORKDAYS function. Also, you will get familiar with two different ways to get workdays between dates. The first one excludes only weekends, while the second one excludes defined holidays’ dates beside weekends.

Get workdays between dates


=NETWORKDAYS(start_date, end_date, [holidays])


The NETWORKDAY function returns a number of working days between two selected days. The function can take in count specified holidays, but it is not mandatory.

The parameters of the function are: start_date – a beginning date of a period for which we want to get workdays between dates; end_date – an ending date of a period for which we want to get workdays between dates; holidays is a non-obligatory parameter which enables the function to take in counts holiday dates and skip them. Therefore to enable this, we need to create a table with all holiday’s dates. Also, we need to define a name for range containing holidays’ dates.

Example 1

In the first example, we will see how to get workdays between dates start date and end date, without taking holidays into account. Let’s see how the formula looks like:




Figure 1. Get workdays between dates excluding only weekends


As you can see in the picture, we want to count workdays between dates in cells B3 and C3 and put it in the cell D3. Therefore, our start date will be 24-Feb-18 and end date will be 28-Feb-18. 24-Feb-18 and 25-Feb-18 are Saturday and Sunday, so the formula will count 26-Feb-18, 27-Feb-18 and 28-Feb-18 and return 3 days in the cell D3.

Example 2

Now we will see how to include holidays when counting workdays between dates. We created a new table which has the list of holidays and their dates and named the range F3:F6 “public_holidays”.

Here is the formula used for this example to get workdays between dates:




Figure 2. Get workdays between dates excluding weekends and holidays


The only difference between this and the first example is filling the parameter Holidays with named range “public_holidays”. Therefore, the number of working days between 14-Feb-18 (B3) and 16-Feb-18 (C3) will be 2 days. 14-Feb-18 was not taken into account, although it is Wednesday, because we put it in our table with holidays.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

i would like to know if there is any way in excel to calculate days between dates and the answer should be devided by month for an example between jan 12 2018 to feb 8 2018 there is 13 workdays in jan and 6 workdays in feb
Solved by Z. L. in 16 mins
Hello, need some help. So I am created a pipeline to track turn-times/due-dates. In this case, D3 shows the date the status was updated. I need D3 to be highlighted orange after 5 workdays have passed and highlighted red if 10 workdays have passed. Please help!
Solved by M. S. in 25 mins
setting automated date formula (with spaces between rows), so that workdays doesn't have to be adjusted manually.
Solved by F. H. in 14 mins

Leave a Comment