Inserting rows with entry of month and dates of two given months

[jassi2006]

Hello Excel Warriors

I am working and trying but failed to achieve the goal.

I want to create an VBA program to create Excel sheet to calculate arrear of pay.

I just want to create list of months automatically between start and end dates in which if the starting date or the end date have only dates then it comes as date from to. Here is the example
If given date is 12-03-2020 to 25-06-2020

Then the result is
12-03-2020 to 31-03-2020
04-2020
05-2020
01-06-2020 to 25-06-2020

OR it will also be ok
12-03-2020 to 31-03-2020
01-04-2020 to 30-04-2020
01-05-2020 to 31-05-2020
01-06-2020 to 25-06-2020

Please help !!

 

[jasonb75]

Duplicate of Rows insert for the period of given dates