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 |
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 |
All times are GMT +1. The time now is 08:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com