Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by Year and Week
Hi,
I am using below dates and convert them to year and week using a formula that looks like this =YEAR(A1)&"/"&WEEKNUM(A1) 5/7/2007 0:00 2007/19 1/9/2007 0:00 2007/2 5/15/2007 0:00 2007/20 The combined year and week is then base for a pivot tabel where I sort the columns by the "Year/week". The problem is that week 2 is sorted after week 19. Is there some way to get the "year/week" to look like this 2007/02 when the week is 1-9? The reason why I can not sort only by week is that I have dates from different year. Sorting by week then mix up data from year 2006 week 2 and year 2007 week 2. Is there some smart person out there who can help me with this problem:)? Patric |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by Year and Week
I've just replied to your other (identical) post - please do not multi-
post. Pete On May 31, 10:32 pm, Patric wrote: Hi, I am using below dates and convert them to year and week using a formula that looks like this =YEAR(A1)&"/"&WEEKNUM(A1) 5/7/2007 0:00 2007/19 1/9/2007 0:00 2007/2 5/15/2007 0:00 2007/20 The combined year and week is then base for a pivot tabel where I sort the columns by the "Year/week". The problem is that week 2 is sorted after week 19. Is there some way to get the "year/week" to look like this 2007/02 when the week is 1-9? The reason why I can not sort only by week is that I have dates from different year. Sorting by week then mix up data from year 2006 week 2 and year 2007 week 2. Is there some smart person out there who can help me with this problem:)? Patric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by week and year | Excel Worksheet Functions | |||
how to insert month date year and day of week | New Users to Excel | |||
Week of the Year | Excel Discussion (Misc queries) | |||
Week/month/year rollovers with PivotTable | Excel Worksheet Functions | |||
first week of year - according to european standard | Excel Worksheet Functions |