List months between two dates

Hi,

What I'm trying to do, for the purposes of a larger macro, is find a way to generate a list of the months and years between two dates.

In cell A2 I have a number for the month (e.g 9 for September), and in A3 I have a year (e.g. 2011). In A5 i have another month (e.g. 2 for February), and in A6 another year (e.g. 2012).

What I want is to generate somewhere a list that uses those two dates and looks like the below (month and year need to be in seperate cells):

9 2011
10 2011
11 2011
12 2011
1 2012
2 2012

Any ideas gratefully received!

thanks,

Jon

Try this:

Please Login or Register  to view this content.

Dom