Posted to microsoft.public.excel.worksheet.functions

RonB

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Weeknum	Mike D.	Excel Worksheet Functions	4	February 14th 06 08:44 PM
Weeknum	MickeW	Excel Worksheet Functions	9	August 23rd 05 08:50 PM
weeknum function says jan1=week1, mod to first 4 day week needed	sam	Excel Discussion (Misc queries)	3	June 13th 05 04:05 PM
WeekNum ISO	RPitoyo	Excel Worksheet Functions	4	December 20th 04 06:24 PM
Weeknum	Christine	Excel Worksheet Functions	3	December 17th 04 10:55 AM

All times are GMT +1. The time now is 02:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us