Work out diffrence between 2 dates minus a couple of holiday range dates

As you can see below, I have a start date and end date which I have worked out the difference using datediff, now I need to somehow minus the days that are in the holiday ranges

excel.PNG


Thanks in advance

I have copied a sheet from an old workbook of mine, and updated the year to 2015, this may get you started in how you can set up some simple calculations. Pretty sure there is a single cell calculation you can also do. But you may be able to combine the formulas so you don't need the helper columns.
HTH