software

I use YEAR(cell)amp;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

You can use this

=YEAR(A2)amp;TEXT(WEEKNUM(A2),quot;00quot;)

--
Regards Ron de Bruin
www.rondebruin.nlquot;RonBquot; gt; wrote in message ...
gt;I use YEAR(cell)amp;WEEKNUM(cell) to organize data in time buckets. This returns
gt; yyyyw numbers for weeks 1 through 9, which when put in a pivot table or
gt; sorted does not sort in a correct date order. Is there a way to force WEEKNUM
gt; toreturn 01 - 09 for weeks 1 thorugh 9 of a given year?
gt; --
gt; RonB
If you want it numeric

=--(YEAR(A2)amp;TEXT(WEEKNUM(A2),quot;00quot;))

--
Regards Ron de Bruin
www.rondebruin.nlquot;Ron de Bruinquot; gt; wrote in message ...
gt; You can use this
gt;
gt; =YEAR(A2)amp;TEXT(WEEKNUM(A2),quot;00quot;)
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;RonBquot; gt; wrote in message ...
gt;gt;I use YEAR(cell)amp;WEEKNUM(cell) to organize data in time buckets. This returns
gt;gt; yyyyw numbers for weeks 1 through 9, which when put in a pivot table or
gt;gt; sorted does not sort in a correct date order. Is there a way to force WEEKNUM
gt;gt; toreturn 01 - 09 for weeks 1 thorugh 9 of a given year?
gt;gt; --
gt;gt; RonB
gt;
gt;
Worked great! Thanks....
--
RonBquot;Ron de Bruinquot; wrote:

gt; If you want it numeric
gt;
gt; =--(YEAR(A2)amp;TEXT(WEEKNUM(A2),quot;00quot;))
gt;
gt; --
gt; Regards Ron de Bruin
gt; www.rondebruin.nl
gt;
gt;
gt; quot;Ron de Bruinquot; gt; wrote in message ...
gt; gt; You can use this
gt; gt;
gt; gt; =YEAR(A2)amp;TEXT(WEEKNUM(A2),quot;00quot;)
gt; gt;
gt; gt; --
gt; gt; Regards Ron de Bruin
gt; gt; www.rondebruin.nl
gt; gt;
gt; gt;
gt; gt; quot;RonBquot; gt; wrote in message ...
gt; gt;gt;I use YEAR(cell)amp;WEEKNUM(cell) to organize data in time buckets. This returns
gt; gt;gt; yyyyw numbers for weeks 1 through 9, which when put in a pivot table or
gt; gt;gt; sorted does not sort in a correct date order. Is there a way to force WEEKNUM
gt; gt;gt; toreturn 01 - 09 for weeks 1 thorugh 9 of a given year?
gt; gt;gt; --
gt; gt;gt; RonB
gt; gt;
gt; gt;
gt;
gt;
gt;