VBA to split start date and end date into days per month in separate rows

[motherindia]

Hello Sir
I have data on sheet1 as follows;

Cust ID	Type	Begin Date	End Date	No of days
1	Luxury	23-Mar-17	23-Mar-17	1
1	Luxury	28-Mar-17	28-Mar-17	1
1	Luxury	29-Mar-17	29-Mar-17	1
1	Luxury	30-Mar-17	30-Mar-17	0.5
1	Luxury	31-Mar-17	31-Mar-17	0.5
1	Luxury	08-Apr-17	08-Apr-17	0.5
1	Luxury	08-Apr-17	08-Apr-17	0.5
1	Luxury	10-Apr-17	12-Apr-17	3

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

Output needed as below;

Cust ID	Type	Month-Year	Day	Total Days
1	Luxury	Mar-17	23,28,29,30,31	4
1	Luxury	Apr-17	8,10,11,12	4

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

Regards, motherindia

<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>

 

[motherindia]

Wow, its working as I expected.
Thanks once again and you are really my great timesaver.

Regards,
motherindia