Excel Question - Autopopulate a Table with Date Ranges

[ricapa]

I have a question...I am bulding a table in Excel which contains on the columns all of the months and in the rows I want to display in automatic the information from another table that I have with all of my contracts (3, 6, 9, 12 months contracts), so basically in my first table I have all of the information regarding when the contract starts and when the contract ends, and I want to auto-populate the income of each month, considering when the contract starts and ends

can someome help me on this question?

thank you
Richard