I tested this in Excel 2010 and 2016. To find the number of weekdays between two dates, simply use the formula =networkdays (Start_date,End_date), with Start_date addressing the cell containing ...

How to exclude holidays in Excel So far, we’ve used NETWORKDAYS () to exclude weekends when counting the number of days between today and the estimated completion date for our projects.