insert column via macro

[1excellentexcel]

I am having two issues with how to insert a column. First is there is a centered merge cell above the column, second where I want to do the insert and copy paste is not at the end. Please see the below. So the "Last 5 days" is center merged over the last 5 days cells of Sept 10th - Sept 16th. What I need the macro to is essentially insert a column between the 15th and 16th and hard code the 16th into the new column. then hide the Sept 10th column. please help. Thanks

Last 5 Days
10-Sep	11-Sep	12-Sep	15-Sep	16-Sep		∆ DOD	∆ QTD

<tbody>
</tbody>