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;

DATE

WEEK NO

<tbody>
</tbody>

03/04/2017	1
04/04/2017	1
05/04/2017	1
06/04/2017	1
07/04/2017	1
08/04/2017	1
09/04/2017	1
10/04/2017	2
11/04/2017	2
12/04/2017	2
13/04/2017	2
14/04/2017	2
15/04/2017	2
16/04/2017	2
17/04/2017	3
18/04/2017	3
19/04/2017	3
20/04/2017	3
21/04/2017	3
22/04/2017	3
23/04/2017	3

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

REQUIRED;

WEEK NO	START DATE	WEEK DAYS END DATE	WEEK END DATE
1	03/04/2017	07/04/2017	09/04/2017
2	10/04/2017	14/04/2017	16/04/2017
3	17/04/2017	21/04/2017	23/04/2017
4	24/04/2017	28/04/2017	30/04/2017
5	01/05/2017	05/05/2017	07/05/2017
6	08/05/2017	12/05/2017	14/05/2017
7	15/05/2017	19/05/2017	21/05/2017
8	22/05/2017	26/05/2017	28/05/2017

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

 

[SAXON10]

please help me.