Quote Originally Posted by Zyphon
Could I use this formula if I had a master spreadsheet to see if my holiday dates clashed with a colleague?
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)?