split date ranges into weeks

[jongooligan]

I've got a sheet where users can input a start date into cells B3:B17 and an end date into cells C3:C17. All start dates are Mondays; all end dates are Sundays; none of the periods overlap.

I need a continuous list of start dates for each week in each of the periods in cells B20:B? (dependent on number of weeks in each period). Also need corresponding week end dates in cells C20:C?

So if B3 = 03/03/2008, C3 = 16/03/2008 and
B4 = 24/03/2008, C4 = 30/03/2008 then

B20 = 03/03/2008, C20 = 09/03/2008
B21 = 10/03/2008, C21 = 16/03/2008
B22 = 24/03/2008, C22 = 30/03/2008

Hope this is clear - sorry not allowed any downloads at work so can't display graphically.

 

[jongooligan]

Anybody?