Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WEENUM into months
Hello,
I need to change weeks into months. Like having weeks 1 through 5 be called Jan. and so on. What is the easiest way to do this. Thanks, Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WEENUM into months
I would have used WEEKNUM in combination with a VLOOKUP. The VLOOKUP should
be used with a hard-coded table where you fill in the weeknumber in column 1 and the corresponding month in column 2. Typical formula can be as follows: =VLOOKUP(A1, A2:B13, 2, True) where your weeknumber is in cell A1, and range A2 through B13 contain the 12 weeks that define the start of a month. This should do the trick. Of course, since the 1st of every month does not fall on the start of a week, you will always have a gray area at the end of each month and start of each month. But that is the degree of precision that you have requested in your question, thus cannot do any better. "Cube Farmer" wrote: Hello, I need to change weeks into months. Like having weeks 1 through 5 be called Jan. and so on. What is the easiest way to do this. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz | Excel Discussion (Misc queries) | |||
Calculate number of years and months employed using hire date and. | Excel Worksheet Functions | |||
Add # of months and get result last day of # months. | Excel Discussion (Misc queries) | |||
months between 2 dates!!! | Excel Discussion (Misc queries) | |||
Why "datedif" function results sometimes negative numbers? | Excel Worksheet Functions |