Calculate date given month and week number in month

[here4real]

I have found multiple ways of calculating the week of a month for a given date. Now, I want to reverse it, i.e. given a month and week and day of week calculate the date. Somewhat stumped here.

Note that in week 1 and last week, there will often be days with no value.

Thanks.

 

[plog]

Can you provide some samples?

 

[here4real]

I ended up getting it...

What I did is calculate the date of the first Sunday of the month and what week it falls in. Then based on that I do DateAdd based on the week difference and adding the individual days of the week.