Date formatiing - using code to show months

[Roger on Excel]

I have a row of dates which start from =TODAY() and increment by 1 along
the row giving a sequential row of dates.

I would like to automatically format the row below the dates to show merged
blocks of months for the day date row above - January, February etc

The day date row of course updates each day so i would like the month row to
reflect this.

For the month row I want to display just a single August or September label
under that row of day dates. But I need it to update as the dates change

So, for September, the month row will be a single horizontally formatted
merged cell with just "September" below the vertically formatted row of days
for that month. This would be the same for subsequent months of course. I
dont want to see the month under each and every date

How would one accomplish this?

Roger

 

[Roger on Excel]

Thanks Martin,

I would want code to have to format the cells automatically - merging cells
manually is not really what I am looking for.

I should have made that clearer in my post.

Regards,

Roger

 

[Peo Sjoblom]

Don't use merged cells at all, there is hardly a worse functionality of
excel, you can get similar layout using multiple cells and center across
selection in the formatting.
In one way or another merged cells will come back and haunt you.


--


Regards,


Peo Sjoblom