How to get month and year from week and year

[Aniket1]

I have data where I am given week numbers from 1 to 52 along with their corresponding years. I want to make a new column which has the month and the year

so say like week 01-04 Jan

05-08 Feb .. so on

I have a separate column  where i have the week numbers stored and another column where the year is.

I want to make it so the new column says Jan-18 for the first row in this case.

[T_Willins]

 @Aniket1,

How do you want to manage where weeks cross over months?  For example, week 5 will be part in January and part in February.

[AbhilashR · Accepted solution]

Hi @Aniket1, does the approach in the attached sample file work for you?

[Aniket1]

It works! Thanks man!