Week number and year in the same cell, convert into month text

[Glenn2290]

Hello,

I'm new here, so sorry if this question is already asked. I tried to look it up in the forum but couldn't find it.

In cell A1, I have my week numbers and year, shown like this: "01 2020". I would like to add a column (B1) named "months" and work with a formula so in that cel will come "January".
My question is, which formula do I need to use

Thx
Glenn

 

[Glenn2290]

The formula that I use now is: =TEXT(DATE(RIGHT(A1;1);1;1)-WEEKDAY(DATE(RIGHT(A1;1);1;1);2)+1+7*(LEFT(A1;2)-1);"mmmm")
But the result is not exactly accurate. Week 36 for example is a split week. Monday is still July and from Tuesday it is August. Is there a solution for split weeks?

 

[afonsomira]

Hello try this formula in B2 if the week and Year start on A2
Formula: =CHOOSE(MONTH(DATE(RIGHT(A2,4),1,LEFT(A2,2)*7-2)-WEEKDAY(DATE(LEFT(A2,2),1,3))),"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December")