Hi guys, i wonder if you can help me - a bit of background first though. I work for a retail company that uses a lot of contractors in their shops to cover when someone is off on holiday or sick or such. Part of my job is downloading an excel report that has a list of dates when the shop needs cover, which i then i have to go through and identify 'blocks' where we have multiple uncovered days clumped together and then book a contractor to cover those days. Is there a way to get excel to autolook through the dates and just highlight any blocks of say 3 or more days that are bunched together, then on a seperate page of the workbook output it along the lines of:
London Store - 23/05 to 27/05 - 4 days required.
I appreciate that this might not make sense, or is an extremely easy/beginner question but any help would be greatly appreciated.