How to convert the month week into date format?

[#1]

Hi all,

I have a date column like this which is belongs to a financial year (Say 2012-2013).

MonthWeek

Apr Week 1

Apr Week 2

Apr Week 3

Apr Week 4

Apr Week 5

May Week 1

May Week 2

May Week 3

May Week 4

May Week 5

Jun Week 1

Jun Week 2

Jun Week 3

Jun Week 4

Jun Week 5

Jul Week 1

Jul Week 2

Jul Week 3

Jul Week 4

Jul Week 5

Aug Week 1

Aug Week 2

Aug Week 3

Aug Week 4

Aug Week 5

Sep Week 1

Sep Week 2

Sep Week 3

Sep Week 4

Sep Week 5

Oct Week 1

Oct Week 2

Oct Week 3

Oct Week 4

Oct Week 5

Nov Week 1

Nov Week 2

Nov Week 3

Nov Week 4

Nov Week 5

Dec Week 1

Dec Week 2

Dec Week 3

Dec Week 4

Dec Week 5

Jan Week 1

Jan Week 2

Jan Week 3

Jan Week 4

Jan Week 5

Feb Week 1

Feb Week 2

Feb Week 3

Feb Week 4

Mar Week 1

Mar Week 2

Mar Week 3

Mar Week 4

Mar Week 5

The data will be updated on sunday of the each week.So i have to find sunday date of each week.

How to find the Sunday date of each week? to convert this column into date format(DD/MM/YYYY)

Please provide your comments and ideas to achieve it.

Thanks in advance.

Regards

Kumar