Merge a set of cells based on set of date cells below

[whitwoo]

Hi there,

I am currently creating a tool that will capture staff holidays and sick. As part of the tool I want the ability to create a new tab with a set calendar format based on the year entered by a user.

As part of this, the format I want to create will have the dates populated from cell G8 across the row for 1 year (in order - timeline) - happy with this part. For the row above I want create a set of merged cells that contain the Month. So I want a function that will analyse row 8 from column G onwards (1 years worth of dates) and then merge the cells above for each month (i.e. G7 to AK7 will be merged and January entered, AL7 to BL7 will be merged and February entered, and so on)

I have attached an example of what I am looking for

Many Thanks