transform data based on calendar

[evalam]

[TABLE="width: 720"]
<colgroup><col><col span="6"><col><col></colgroup><tbody>[TR]
[TD]M[/TD]
[TD]T[/TD]
[TD]W[/TD]
[TD]H[/TD]
[TD]F[/TD]
[TD]S[/TD]
[TD]U[/TD]
[TD]starting date [/TD]
[TD]ending date [/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]29/4/2013[/TD]
[TD]7/10/2013
[/TD]
[/TR]
</tbody>[/TABLE]
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

[TABLE="width: 158"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]29-Apr-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]6-May-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]13-May-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]20-May-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]27-May-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]3-Jun-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]10-Jun-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]17-Jun-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]24-Jun-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1-Jul-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]8-Jul-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]15-Jul-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]22-Jul-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]29-Jul-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]5-Aug-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]12-Aug-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]19-Aug-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]26-Aug-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]2-Sep-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]9-Sep-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]16-Sep-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]23-Sep-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]30-Sep-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]7-Oct-13[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

any ideas ?

 

[yesterdays]

Try this:
[TABLE="class: grid, width: 774"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]M[/TD]
[TD="align: center"]T[/TD]
[TD="align: center"]W[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]U[/TD]
[TD="align: center"]starting date[/TD]
[TD="align: center"]ending date[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]29/04/2013[/TD]
[TD="align: center"]07/10/2013[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]29/04/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]06/05/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]13/05/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]20/05/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]27/05/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]03/06/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]10/06/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]17/06/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]24/06/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]01/07/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]08/07/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: center"]15/07/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]22/07/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: center"]29/07/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: center"]05/08/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: center"]12/08/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: center"]19/08/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]26/08/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: center"]02/09/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: center"]09/09/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: center"]16/09/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: center"]23/09/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: center"]30/09/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: center"]07/10/2013[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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 :
[TABLE="width: 647"]
<tbody>[TR]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]30/4/2013[/TD]
[TD]24/9/2013[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]15/5/2013[/TD]
[TD]25/9/2013[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4/7/2013[/TD]
[TD]29/8/2013[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3/6/2013[/TD]
[TD]30/9/2013[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]5/6/2013[/TD]
[TD]25/9/2013[/TD]
[/TR]
</tbody>[/TABLE]
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