How do you convert week number to month name given:
A:A = Week number, B:B = Year
e.g A1 = 6, B1 = 2013 will give us February
How do you convert week number to month name given:
A:A = Week number, B:B = Year
e.g A1 = 6, B1 = 2013 will give us February
How to you define week numbers ? ISO?Absolute? http://www.cpearson.com/excel/WeekNumbers.aspx
Not quite what i am looking for......
Hi
So what happens when the week number spans 2 months. ie Week number 5: 27/01/2013-02/02/2013
Regards Kevin
Merged Cells (They are the work of the devil!!!)
I'm sure there must be an easier way, but how about this:
=TEXT(DATE(B2,1,1+MATCH(A2,WEEKNUM(ROW(INDIRECT(DATE(B2,1,1) & ":" & DATE(B2,12,31))),1),0)-1),"mmm")
Which is an array formula, so must be entered with Ctrl-Shift-Enter, not just enter.
This one? Format cell as "mmmm"
=DATE(B1,1,-2)-WEEKDAY(DATE(B1,1,3))+A1*7
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks