transform data based on calendar

[evalam]

M	T	W	H	F	S	U	starting date	ending date
1	0	0	0	0	0	0	29/4/2013	7/10/2013

<colgroup><col><col span="6"><col><col></colgroup><tbody>
</tbody>

hey guys i have the previous data set which represent a flight that starts 29/4/2013 and ends 7/10/2013
and is going to take place every monday
i need to transform it in the following form but ihave no idea on how to do it

29-Apr-13	1
6-May-13	1
13-May-13	1
20-May-13	1
27-May-13	1
3-Jun-13	1
10-Jun-13	1
17-Jun-13	1
24-Jun-13	1
1-Jul-13	1
8-Jul-13	1
15-Jul-13	1
22-Jul-13	1
29-Jul-13	1
5-Aug-13	1
12-Aug-13	1
19-Aug-13	1
26-Aug-13	1
2-Sep-13	1
9-Sep-13	1
16-Sep-13	1
23-Sep-13	1
30-Sep-13	1
7-Oct-13	1

<colgroup><col><col></colgroup><tbody>
</tbody>

any ideas ?

 

[yesterdays]

Try this:

	A	B	C	D	E	F	G	G	I
1	M	T	W	H	F	S	U	starting date	ending date
2	1	0	0	0	0	0	0	29/04/2013	07/10/2013
3	29/04/2013
4	06/05/2013
5	13/05/2013
6	20/05/2013
7	27/05/2013
8	03/06/2013
9	10/06/2013
10	17/06/2013
11	24/06/2013
12	01/07/2013
13	08/07/2013
14	15/07/2013
15	22/07/2013
16	29/07/2013
17	05/08/2013
18	12/08/2013
19	19/08/2013
20	26/08/2013
21	02/09/2013
22	09/09/2013
23	16/09/2013
24	23/09/2013
25	30/09/2013
26	07/10/2013

<tbody>
</tbody>

A3:
=IFERROR(INDEX(ROW(INDIRECT($H$2&":"&$I$2)),SMALL(IF(WEEKDAY(ROW(INDIRECT($H$2&":"&$I$2)),2)=($A$2:$G$2*COLUMN($A$1:$G$1)),ROW(INDIRECT("1:"&($I$2-$H$2+1)))),ROW(1:1))),"")
Ctrl Shift Enter
Work even more day been marked

 

[evalam]

thank you so much it works but when i need to add more lines for example :

0	1	0	0	0	0	0	30/4/2013	24/9/2013
0	0	1	0	0	0	0	15/5/2013	25/9/2013
0	0	0	1	0	0	0	4/7/2013	29/8/2013
1	0	0	0	0	0	0	3/6/2013	30/9/2013
0	0	1	0	0	0	0	5/6/2013	25/9/2013

<tbody>
</tbody>

it gives me blank cells ...

 

[yesterdays]

No No, don't add more line, use the 1st one
From A2:G2, tick 1 to which day you want it to show

 

[evalam]

thank you so much