Re: Business Days - holidays and weekends
as an aside... would anything like this be viable for you?
unlikely if you really need the matrix as per your other sheet - this way shows how to use a pivot table instead ... do your calcs as additional fields - no requirement for VBA.
that said I will come up with an alternative.
do you have a list of the dates you want excluded from the workingdays calcs - ie those holidays falling midweek?
if so can you provide us with it - XL will not be able to establish these dates itself ... it is not set up with public holiday info.