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