Min and max against date

[SAXON10]

Hi,

DATA;

Column A and B is contain of finical year dates and week no from 2017 to 2018. Weekdays start Monday to Sunday.

REQUIRE FORMAT;

Week no return week starting date, weekdays end date and week end date.

file shared for your reference.

Dropbox - DATE.xlsx


DATA;

[TABLE="width: 158"]
<tbody>[TR]
[TD]DATE[/TD]
[TD]WEEK NO[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 158"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]03/04/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]04/04/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]05/04/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]06/04/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]07/04/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]08/04/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]09/04/2017[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10/04/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]11/04/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]12/04/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]13/04/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]14/04/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]15/04/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]16/04/2017[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]17/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]18/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]19/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]20/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]21/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]22/04/2017[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]23/04/2017[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

REQUIRED;

[TABLE="width: 433"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]WEEK NO[/TD]
[TD]START DATE[/TD]
[TD]WEEK DAYS END DATE[/TD]
[TD]WEEK END DATE[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]03/04/2017[/TD]
[TD="align: right"]07/04/2017[/TD]
[TD="align: right"]09/04/2017[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]10/04/2017[/TD]
[TD="align: right"]14/04/2017[/TD]
[TD="align: right"]16/04/2017[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]17/04/2017[/TD]
[TD="align: right"]21/04/2017[/TD]
[TD="align: right"]23/04/2017[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]24/04/2017[/TD]
[TD="align: right"]28/04/2017[/TD]
[TD="align: right"]30/04/2017[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]01/05/2017[/TD]
[TD="align: right"]05/05/2017[/TD]
[TD="align: right"]07/05/2017[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]08/05/2017[/TD]
[TD="align: right"]12/05/2017[/TD]
[TD="align: right"]14/05/2017[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]15/05/2017[/TD]
[TD="align: right"]19/05/2017[/TD]
[TD="align: right"]21/05/2017[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]22/05/2017[/TD]
[TD="align: right"]26/05/2017[/TD]
[TD="align: right"]28/05/2017[/TD]
[/TR]
</tbody>[/TABLE]

 

[SAXON10]

please help me.