Calculating a Month from a week & year

[TaffyMac1971]

Hello All

new to this and wondering if someone could assist me?

I have the below formula in a spreadsheet with a view to calculating a month value from a year and week #
the formula below is linked to a parameters tab and I am nowhere near savvy enough to figure this error out.

my main question then I suppose is...! is their a formula to get this data without using the vLookup & Parameters sheet?

your assistance with my dilemma would be greatly appreciated.


=VLOOKUP(G12&G6,SetUp!CC7:CD162,2,FALSE)

 

[AhoyNC]

See if this link helps.

How to get month from week number and year in Excel?

 

[TaffyMac1971]

It may be my inexperience but this doesn't help.

thank you for trying however