Quote Originally Posted by daddylonglegs
You may need a different approach. The above allows you to check a single range against a list. Presumably to do what you suggest you might want to check multiple ranges (your holiday dates) against another set of multiple ranges (a colleagues holiday dates)?
Yes I was thinking along those lines. Maybe have say a master spreadsheet that would have all my colleagues holiday dates and to check against those ranges. Although at this moment in time I have no idea of how to achieve this as it sounds quite complex.