Calculate date given month and week number in month (1 Viewer)

H

here4real

Registered User.

Local time

Today, 10:16

Joined

May 1, 2013

Messages

87

• Mar 3, 2014

• #1

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.

 

P

plog

Banishment Pending

Local time

Today, 09:16

Joined

May 11, 2011

Messages

11,634

• Mar 3, 2014

• #2

Can you provide some samples?

 

H

here4real

Registered User.

Local time

Today, 10:16

Joined

May 1, 2013

Messages

87

• Mar 3, 2014

• #3

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.