Convert Month, Week, Year to date

[Pete Hay]

What is the easiest way to convert three values - Month, Week, Year to a
date? Date would be the Monday of the week specified.
Pete

 

[David Biddulph]

You'll need to specify how you define the week number within a month?
Is week 1 always 1st to 7th?
Presumably the Monday of week 5 can actually fall in the next month?

Perhaps:
=DATE(C2,A2,B2*7-6)+MOD(7-WEEKDAY(DATE(C2,A2,B2*7-6),3),7)

 

[Pete Hay]

I'm trying to convert job schedules to start dates for import into MS
Project. My jobs/tasks are listed for example: the 3rd week of every month,
or 2nd week of every 3rd month (quarterly). I don't think 5th week is an
issue.
Pete

 

[Fred Smith]

You haven't helped very much, Pete. Did David's formula work for you? If
not, what did it give you, as opposed to what you needed. You could also
answer the question he asked: what date is the "3rd week of every month"?

Regards,
Fred