If your field has text or blanks, then you can't use that grouping.

Excel has a =weeknum() function that might be ok right out of the box.

=if(a2="","",weeknum(a2))
???


neowok wrote:

the dates are in 2 columns, i went to group but cant see how i could
group them by week (no options for this)

top few cells of one of the planned date column and 2 extra needed for
the graph may look something like this if it all works

Planned week ending numberof items
01-01-06 01-01-06 3
<blank cell 08-01-06 2
<blank cell 15-01-06 1
05-01-06 26-02-06 1
01-01-06
01-01-06
25-02-06
<blank cell
<blank cell
15-01-06
03-01-06
<blank cell
etc etc

the graph could then be based on the week ending and number of items
column for the planned series, and then the same thing again for the
actual series.

I think i need to get an automated split of weeks in one column (B)
(ending on say sundays) and then in column C, the number of dates in
column A which falls during the week in column B

if not that then some other way of getting the same sort of result just
so I can draw the graph.

--
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