Generating a list of dates within ranges?

Hi All!

I am a decent Excel data manipulator who is familiar with formulas and filtering, but don't have any programming/VBA skills.

I am trying to solve this challenge: I have a start date and end date column, and what I want to create is a list of all the dates between the start and end date, each on their own row.

I don't think there's a formula for this, so I have posted here.

I know there's a way to do this in SQL, (but am trying to work this into a regular use spreadsheet).

So the hypo is really simple:

Start Date, End Date
1/1/2013,1/5/2013
1/7/2013,1/8/2013

Results of macro/script:
1/1/2013
1/2/2013
1/3/2013
1/4/2013
1/5/2013
1/7/2013
1/8/2013

Please let me know with questions, and thanks in advance!!!

Martin

thank you very much for the response!

pardon my ignorance, but which portions of the post should I replace with the columns that have my start date end date?

Thank you!

Worked perfectly, thanks so much Martin!!!