Workdays per month excluding holidays help required with Formula

Good Morning

I have a spreadsheet (Excel 2013) that will have various date ranges that spread over more than one month. I need to work out how many workdays fall into each separate month that the date range covers but also take into account holiday dates and reduce the days accordingly.

I have a formula which will return the workdays per month and have set a range with the holiday dates called holidays however cannot work out where in the formula to show this and to ensure it will only use holiday dates which fall within that particular month.

The formula I currently have is =NETWORKDAYS(MAX($A$3,C1),MIN($B$3,EOMONTH(C1,0))) in C3 which is returning 9 working days for May which is correct for that formula but I also need to to take into account that the 28/5/18 is a holiday and return 8 working days. I have attached a copy of what I am working on to give an idea hopefully.

Many thanks in advance

You are so close and have even named the range
=NETWORKDAYS(MAX($A$3,C1),MIN($B$3,EOMONTH(C1,0)),Holiday)

or
=NETWORKDAYS(MAX($A$3,C1),MIN($B$3,EOMONTH(C1,0)),a8:a16)

That's it - works a treat, thanks!!