| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WEEKNUM
I use YEAR(cell)&WEEKNUM(cell) to organize data in time buckets. This returns
yyyyw numbers for weeks 1 through 9, which when put in a pivot table or sorted does not sort in a correct date order. Is there a way to force WEEKNUM toreturn 01 - 09 for weeks 1 thorugh 9 of a given year? -- RonB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WEEKNUM
You can use this
=YEAR(A2)&TEXT(WEEKNUM(A2),"00") -- Regards Ron de Bruin http://www.rondebruin.nl "RonB" wrote in message ... I use YEAR(cell)&WEEKNUM(cell) to organize data in time buckets. This returns yyyyw numbers for weeks 1 through 9, which when put in a pivot table or sorted does not sort in a correct date order. Is there a way to force WEEKNUM toreturn 01 - 09 for weeks 1 thorugh 9 of a given year? -- RonB |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WEEKNUM
If you want it numeric
=--(YEAR(A2)&TEXT(WEEKNUM(A2),"00")) -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... You can use this =YEAR(A2)&TEXT(WEEKNUM(A2),"00") -- Regards Ron de Bruin http://www.rondebruin.nl "RonB" wrote in message ... I use YEAR(cell)&WEEKNUM(cell) to organize data in time buckets. This returns yyyyw numbers for weeks 1 through 9, which when put in a pivot table or sorted does not sort in a correct date order. Is there a way to force WEEKNUM toreturn 01 - 09 for weeks 1 thorugh 9 of a given year? -- RonB |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WEEKNUM
Worked great! Thanks....
-- RonB "Ron de Bruin" wrote: If you want it numeric =--(YEAR(A2)&TEXT(WEEKNUM(A2),"00")) -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... You can use this =YEAR(A2)&TEXT(WEEKNUM(A2),"00") -- Regards Ron de Bruin http://www.rondebruin.nl "RonB" wrote in message ... I use YEAR(cell)&WEEKNUM(cell) to organize data in time buckets. This returns yyyyw numbers for weeks 1 through 9, which when put in a pivot table or sorted does not sort in a correct date order. Is there a way to force WEEKNUM toreturn 01 - 09 for weeks 1 thorugh 9 of a given year? -- RonB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weeknum | Excel Worksheet Functions | |||
| Weeknum | Excel Worksheet Functions | |||
| weeknum function says jan1=week1, mod to first 4 day week needed | Excel Discussion (Misc queries) | |||
| WeekNum ISO | Excel Worksheet Functions | |||
| Weeknum | Excel Worksheet Functions | |||
Linear Mode
