Or instead of using the week number, use the date of the first day in the week
(or the Friday of that week or...)

neowok wrote:

hm might be able to use severla more columns and use weeknum. i can use
a macro to copy the weeknum formula down for however many rows the
dates go, then maybe make a pivot table of that column giving me a
count of each weeknum, then somehow convert the weeknums into weeks
that i can use as x axis labels and base the chart off the pivottable
but without using a pivotchart. or something, but thats probly a bit
too complicated to work hehe ill have to fiddle with it on monday

--
neowok
------------------------------------------------------------------------
neowok's Profile: http://www.excelforum.com/member.php...fo&userid=5940
View this thread: http://www.excelforum.com/showthread...hreadid=505716

--

Dave Peterson