How to convert Weeks to Month?

Options
Kayley
Kayley Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi All,

 

I have a list with custom month format and the list code is 'mmm-yy Code' example: 'Apr-21 VLIB0065E' (below image)

 

Kayley_1-1626924628582.png

 

However, the source file i have received is in Year-Week example '2021-01' (2021 = Year, 01- first week of 2021 which is Jan)

 

How do i convert weeks to month?

 

Kayley_0-1626924522736.png

 

 

Tagged:

Categories