Convert Week number into Month
This needs "ROW(A$1:A$366)" or you will get things like 6 weeks in January and the formula gets exhausted while still in November after 53 weeks.
On Friday, May 28, 2010 7:19:29 PM UTC+2, Lars-Åke Aspelin wrote:
Remove the call to MONTH() and the formula will work better.
=TEXT(DATE(A1,1,MATCH(B1,INDEX(WEEKNUM(DATE(A1,1,R OW(A1:A366)),2),),0)),"MMMM")
Lars-�ke
On Fri, 28 May 2010 12:02:13 +0100, "Steve Dunn"
wrote:
=TEXT(MONTH(DATE(A1,1,MATCH(B1,INDEX(WEEKNUM(DATE (A1,1,ROW(A1:A366)),2),),0))),"MMMM")
Which does *not* need to be array entered.
HTH
Steve D.
"KT" wrote in message
I have a worksheet with values for year and week number. I need to convert
these to the descriptive month name. Some weeks cross month ends, but
this
is okay, I just need a single value for each record. It could be the
month
of the first day of each week number. Using Excel 2003.
Thanks for your ideas.
|