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.
Solved! Go to Solution.
How do you want to manage where weeks cross over months? For example, week 5 will be part in January and part in February.
It works! Thanks man!