Looping Generating Specific Dates in Six Month Intervals between end and start date

Hi,

I have a fairly urgent question.

I am looking to generate a list of dates between a start date and an end date. The dates between those two periods would be 6 months + the start date.

For example:

If the start date was June 1, 2009 and the end date was September 1, 2010, I would like a list of the dates: September 1, 2009, June 1, 2010. If possible, the two dates would each be in their own excel column.

I would then have to loop this until there was a blank cell---repeating this command for each row of data, each having a differnet start and end date. For example:

A1 would be the first start date of June 1 2009, with B1 the end date of Sept 1 2010
A2 would be the second start date of October 15 2009 and B2 the end date of Dec 1 2009

ideally the dates between the first start and end date would occupy C1 and D1 and so on

Any help would be very greatly appreciated!!

I apologize that it was unclear

1) I added incorrectly ; I should have taken more care

2) the values in the second row are completely separate from the values in the first row--they should have their own listing

3) I am going to execute this on a work computer which is VBA enabled, as well as on a large data set, which is why i was looking for a code that would generate these dates for each row

4) attached is an example of the desired end result. the before would just be a list of start and end dates.

i hope this is more clear. let me know if further clarification is needed. Thanks, I appreciate the input!

Thanks! I don't have much experience working with Excel--I really appreciate this!