Convert Month, Week, Year to date
 

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

Convert Month, Week, Year to date
 

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)
--
David Biddulph

Pete Hay wrote:
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

Convert Month, Week, Year to date
 

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

"David Biddulph" wrote:

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)
--
David Biddulph

Pete Hay wrote:
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


.

Convert Month, Week, Year to date
 

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

"Pete Hay" wrote in message
...
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

"David Biddulph" wrote:

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)
--
David Biddulph

Pete Hay wrote:
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


.