Skip to content

Calculate the Number of Workdays

This article is all about how to use the NETWORKDAYS function to calculate the number of workdays between two dates.

If that sounds like something you want to learn, then keep on reading!

The NETWORKDAYS Function

The NETWORKDAYS function calculates the number of workdays between two days.

In this function, workdays are considered to be Monday through Friday, with the exclusion of Saturday and Sunday.

The NETWORKDAYS function accepts up to three arguments.

=NETWORKDAYS(Start_date, End_date, Holidays)
  • Start_date – This is the date that will start the count of work days. This date is included in the count. (Required)
  • End_date – This is the date that will end the count of work days. This date is included in the count. (Required)
  • Holidays – This argument can be a list of date serial numbers that represent holidays, or it can be a reference to a range containing dates. These dates are excluded from the work days count. (Optional)

Take a look at how the NETWORKDAYS function is used in the example below.

The NETWORKDAYS function takes the start date and end date and calculates the number of workdays between the two. As you can see from the diagram below, the final count is correct.

Add Holidays to the NETWORKDAYS Function

If you want the NETWORKDAYS function to consider certain holidays (official or not), you can specify which days it should ignore when counting workdays.

Here is an example.

This time, the NETWORKDAYS function is set up to consider the dates in E3:E5 as holidays and therefore ignore them when counting the workdays.

The function does its thing and comes up with a final count of 19, which is once again correct.

 

The NETWORKDAYS.INTL Function

The NETWORKDAYS.INTL function is similar to the NETWORKDAYS function, but it adds one more argument to the mix.

=NETWORKDAYS.INTL(Start_date, End_date, Weekend, Holidays)
  • Weekend – This argument allows you to customize which days are considered as the weekend. (Optional)

Here is how you can use the NETWORKDAYS.INTL function to only count Wednesdays as the weekend and include all other weekdays in the work days final count.

The NETWORKDAYS.INTL function counts each day as a work day, except Wednesdays of course, and comes up with a count of 27.

As you can see from the calendar below, this is correct.

For details on configuring the NETWORKDAYS.INTL function to ignore specific days, check out this article.

And that is how you can calculate the number of workdays in Microsoft Excel!

This Post Has One Comment

  1. I didn’t know you could add holidays to this! I needed this information a long time ago!! Thanks for making my life easier as always!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top