Generate all payments of a year question

Dear community,

I am working on a little book keeping file and stumbled on a slight issue.

For this specific problem I am working on generating a list of all my payments when selecting the term, start date and End of year date.
See the attached picture for my Excel sheet.
Example.PNG

What I would like to create is a list that automatically displays all my payment dates based on what I select as the term, start date and end date such as this:
Type Payment date Amount
House Insurance 8-1-2014 200
House Insurance 15-1-2014 200

Lets say for example I would change the term from weekly to monthly then it would look like this:
Type Payment date Amount
House Insurance 8-1-2014 200
House Insurance 8-2-2014 200

I need to create a formula which enables me to add other insurances and still generates the list. Could anyone help me with this?

It would be much appreciated!

Thanks in advance

Attached uses a dropdown list to allow the selection of weekly vs monthly (list stored in B45:B46). Start date is hard coded in. The rest auto-calculates. Reply if you have any further questions. If this solves your question, please mark the thread as "SOLVED".

Thank you for your reply. Unfortunately this is not exactly what I mean.

I have created a file which helps me to explain my problem.
test.xlsx

What I want is a list that becomes bigger or smaller depending on the total amount of payments that have to be made. For example when 50 payments have to be made, I want that excel generates a list for me containing the 50 payments including the payment dates. I hope this makes more sense than my last explanation. Could you help me with this?

If 50 payments have to be made, or any other number you decide, what's the basis for determining the frequency and time period between payments?

The basis for determining the frequency is through the term cell. I have the option of choosing weekly,fortnightly,monthly etc. The time period is from the start date till the end of the year date.

E.G.
Start date
1-3-2014
End Date
31-12-2014
Frequency = Monthly