| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF? week, month & year-to-date totals | Excel Worksheet Functions | |||
| How do I convert a date to a week of the year? | Excel Discussion (Misc queries) | |||
| how to insert month date year and day of week | Excel Discussion (Misc queries) | |||
| how to insert month date year and day of week | New Users to Excel | |||
| how to insert month date year and day of week | Excel Worksheet Functions | |||
Hybrid Mode
