Convert Month, Week, Year to date

  • Thread starter Thread starter Pete Hay
  • Start date Start date
P

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
 
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
 
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
 
Back
Top