How to Count Working Days in Excel
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.
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.
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.