jongooligan
Board Regular
- Joined
- Jul 23, 2007
- Messages
- 90
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.
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.