In other words, instead of =networkdays (a1,a2), enter =networkdays (a1,a2,holidays). The weekdays where your office is closed will no longer be counted in the formula.

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.