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;
<tbody>
DATE
WEEK...