Count Working Days in Excel

How to Count Working Days in Excel

 
Microsoft Excel is also very good in date analysis. One of the function that you might need to learn is Networkdays which can count the number of working days given the start date, end date and optional holidays.

Evaluation of Formula
It is fairly easy to count the calendar days given a date range in Excel, but what about the working days. In the example below, we will count the working days in between December 1 to December 31, 2017. Holidays can also be defined in this function.
 
Excel Networkdays Function
 
Result of Formula
From the calendar below the number of working days is 19 considering 2 holidays in the month of December. This matches the calculated days using Excel. Counting days in date ranges from months to years can be very easy using Networkdays function.
 
Calendar
 
Excel Networkdays Function 2
 
 
Show Comments
 

About Us

Excelcrib was founded in November 2017 by Garry, a Microsoft® Office Excel® (MS Excel) enthusiast with background in engineering. He's been using MS Excel for more than 15 years in practice with specialty in VBA.

© Copyright 2021 Excelcrib | Privacy Policy

We use cookies to improve your browsing experience.
Continuing to use this site means you agree to our use of cookies.
Tell me more!