Is there a way of calculating the number of holidays that occur between 2 dates. eg I have a table that stores my holidays and want to calculate the no of days between a start and end date but also count the no of holidays separately
Hope this makes sense.
Ive looked at DateDiff but this doesnt do what I want.
Any advice gratefully received