Hello,
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!
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!