Year and Week number but I need to convert to the date of that weeks start

Hello

I REALLY hope someone can help me. When I download my data I get Cell A containing 201722 where 2017 is the year and 22 is the week of that year. I need to insert column B and make it show the Mondays date of that week ie Im expecting outcome to be 29/5/17

How do I do this?

Try:

=DATE(LEFT(A1,4),1,1)+RIGHT(A1,LEN(A1)-4)*7-7

Try

=DATE(2017,1,1)+(RIGHT(A1,2)-1)*7-WEEKDAY(DATE(2017,1,1)+(RIGHT(A1,2)-1)*7)+2

You could put "start date" of 01/10/2017 in a cell e.g X1..

=X1+(RIGHT(A1,2)-1)*7-WEEKDAY(X1+(RIGHT(A1,2)-1)*7)+2

Edit:

=WORKDAY.INTL(DATE(LEFT(A1,4),1,0),RIGHT(A1,LEN(A1)-4),"0111111")

Ok this works, although its putting in the Sundays date and I would like the Mondays date so I altered to
=DATE(LEFT(A1,4),1,1)+RIGHT(A1,LEN(A1)-4)*7-6 and seems to work, thanks

The other options Im struggling with at present so can someone advise if there is an issue with the first reply?:

=DATE(LEFT(A1,4),1,1)+RIGHT(A1,LEN(A1)-4)*7-6

Actually doesn't seem to work if 2016, or 2018 as its just putting same date in with different year ie not working correctly

=DATE(LEFT(A3,4),1,1)+CHOOSE(WEEKDAY(DATE(LEFT(A3,4),1,1)),1,0,6,5,4,3,2)+(RIGHT(A3,2)-1)*7

This one seems to work for all years so seems to do the trick. You guys are awesome cheers