I would like to use NETWORKDAYS to calculate the number of working days between two dates, not counting public holidays.
Help mentions how to use a range of cells as a source for these days. I have found I can specify a single date like this:
=NETWORKDAYS(D16,D12,DATE(2018,8,15))
which will correctly reduce the number of working days by one. However, I haven’t been able to figure out how to specify more than one date in the formula.
What do I do if I have no range of cells but would like to specify multiple dates in the formula itself?