Convert Month, Week, Year to 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
 
P

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
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Week number into Month 5
Convert Week number to Month 0
weekday last year 2
Weekending Date w/Less Than 3 days Assoc. with Prior Month 7
Excel Vba to change displayed year automatically. 14
convert date to Day of the Week 2
How do I get the week in month from a date? 2
Convert Date in Text to month and Year 3

Top