Hello all - first post (I think) so here's hoping someone out there might be able to help me.

Here is my scenario:

I am working on a spreadsheet for work. The file will be updated every Monday so the file will be laid out like this:

Cell A1 = Date (of the Monday of that week) - so today would be 21 Feb 2011

Row A2 to AM2 would take me out to 31 Mar 2011

Then I would like to see AN = April, AO = May, AP = June, AQ = July

Now, I can do this today.

However when I change the date for the file next week to Feb 28 2011 I will then run into April 1st to the 7th before Cell AN which will display April as a monthly 'bucket'.

So - what I'd understand is this:

I want to look out 6 months. 2 months in days, 4 months in months.

Is there a way Excel can show dates out to the end of month 2 and then show 4 months - regardless of the date you put into Cell A1? I want to avoid having some days showing for a month which also has a Cell to its own.

Hopefully I've explained that one OK.

Any help would be great.

Many thanks