How to determine a month from a week number?

Database

How to determine a month from a week number?

Hi Guys,

How can I determine a particular month using the week number or ISO week number? For instance, week 4 belongs to January. But there are some weeks which belong to two month, for instance, week 5 belongs to both Janualy and Feburary.

How can I write a query to determine if the week falls into a single month, display the month, otherwise display the first month?

Thanks in advanced