Find intermediate months of start and end months of a period

[girapas]

In order to lookup monthly data of a database (in which data are listed by date), for a specific period, a user enters in cells say B2 to B5:
A month from: [..] (as month number, e.g. 9, I've named it Month_From )
The year of month from: [....] (e.g. 2012, I've named it Year_Month_From )
A month to: [..] (e.g. 2, I've named it Month_To )
The year of month to: [....] (e.g. 2013, I've namedit Year_Month_To )

After entering:
In cells K2,K3 I get Month_From and Month_To.
In cells L2,L3 I get Year_Month_From and Year_Month_To.

How can I, automatically, get intermediate months' numbers, in K4 and below (e.g. 10,11,12,1) and corresponding years for each month, in L4 and below (e.g. 2012,2012,2012,2013)?
Thanks in advance.

 

[Marcelo Branco]

Maybe...

K4
=IF(DATE($L$3,$L$2,1)>DATE($K$3,$K$2+ROWS($K$4:K4),1),MONTH(DATE($K$3,$K$2+ROWS($K$4:K4),1)),"")
copy down

L4
=IF(DATE($L$3,$L$2,1)>DATE($K$3,$K$2+ROWS($L$4:L4),1),YEAR(DATE($K$3,$K$2+ROWS($K$4:L4),1)),"")
copy down

M.

 

[girapas]

All other OK, but in L4 I get year 1912 instead of 2012 and 1913 instead of 2013 (?)

 

[girapas]

OK. I fix it. Thank you for you help.

 

[Marcelo Branco]

OK. I fix it. Thank you for you help.

You are welcome. Thanks for the feedback.

M.