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 wrote:
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?

Hi Roger,

Format the month row as mmmm (using Custom format), then merge the cells
as needed.

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

"smartin" wrote:

Roger on Excel wrote:
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?

Hi Roger,

Format the month row as mmmm (using Custom format), then merge the cells
as needed.

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




"Roger on Excel" wrote in message
...
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