I need to find out a way to make a date range out of a starting date and an ending date

i.e.

a1 6/25/2007

a2 7/4/2007

what i want then is for collumn b to have all the date inbetween those two dates written out

b1 6/25/2007

b2 6/26/2007

b3 6/27/2007 etc.

I am using this formula in a macro, so each date range is going to be different in size, so I need a formula that is flexible for all date ranges

Thanks!