View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DKS DKS is offline
external usenet poster
 
Posts: 103
Default 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