Month name from week number and Year

[willow1985]

How to do get a Month name from a week number and Year? Been looking online and cannot seem to find one that works.

Thanks

Individual KPI.xlsm
	A	B
1	2022	Week Number
2	December	48
3		47
4		45
5		44
Graph Data

Cell Formulas
Range	Formula
A1	A1	=YEAR(TODAY())
B2:B35	B2	=SORT(UNIQUE(CC[Week Number]),1,-1)
Dynamic array formulas.

 

[iggydarsa]

This might help

 

[willow1985]

Thank you

 

[Tom.Jones]

one more...if need only TEXT....
=TEXT(DATE(A2,1,(B2-1)*7+1), "mmmm")

 

[alansidman]

An alternative is Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
    #"Demoted Headers" = Table.DemoteHeaders(Source),
    #"Filled Down" = Table.FillDown(#"Demoted Headers",{"Column1"}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Filled Down", [PromoteAllScalars=true]),
    #"Renamed Columns" = Table.RenameColumns(#"Promoted Headers",{{"2022", "Year"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Year", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Month", each Date.Month(Date.AddWeeks(#date([Year],1,1),[Week Number])))
in
    #"Added Custom"