I have 2 sets of date ranges:
1) a list of statutory holiday dates for the current year (ie boxing day,
Easter, etc)
2) a list of 52 weeks for the current year with only Saturday and Friday
dates that represent the start and end date of billing weeks (for example,
Sat Jan 6 and Friday Jan 12 for week 1, Sat Jan 13 and Fri Jan 19 for week 2
and so on).

I would like to be able to count the number of business days per week - but
in order to do this accurately I need to know which weeks have a stat
holidays so that the stat holiday will not count as a business day.

I tried using variations of vlookup, but I don't this this will work.

Any ideas?