I have an excel spreadsheet that marks holidays underneath days. What I would like to do is to group the dates starting weekly, instead of daily. This is a snapshot of what it looks like;

jpg.jpg

As you can see the top row is listed daily, as I said I would like for this to consolidate to weekly and the individual cells that contain whether or not the person is on holiday to get smaller.

Is there a way of doing this?