Macro to group columns based on date

[misterg24]

Hi all,

I have a daily excel model, where each column represents a day. The first date is a manual input that can be basically any date.

Is it possible to have a macro that will automatically group together all columns of the same month?

Eg if my starting date is 4th January 2022, the macro would group all columns from 4th to 31st January, then subsequently all columns for Feb, all columns for March etc


Thank you in advance for any help !

 

[misterg24]

Below is an extract of the model structure, where each column is a day. Is it possible to design a macro to group the columns by months, allowing for flexible input dates?