Week into Months

[UKPQ]

Hi All,

I am trying to convert weeks into months. I have weeks from 1 to 52 and I want them to convert into months from 1 to 12 but I condition if the weeks split into two months like week 5 is splitting into Jan & Feb in that case the week should fall into that month where more days are coming like for week 5  - 3 days are coming in jan month & 4 days are coming into feb so it should be considered into Feb month and same logic should be added to rest of weeks & month.

I am using this calculation right now - DateTimeFormat(DateTimeAdd(ToString([Year])+'-01-01',[Week (2023)]*7-1,'day'),'%m') but it is not giving me the desired result.

Looking forward for some positive response.

[ChrisTX]

I think you'll need more than one formula.  Take a look at the field New Month in the attached workflow.

Chris