Hi
I would start using a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...ble/trackback/

--
Regards
Frank Kabel
Frankfurt, Germany
"RJB" schrieb im Newsbeitrag
...
I have three years' worth of sales data, by transaction.

Example:

1/2/2002 5
1/2/2002 2
1/2/2002 3
1/3/2002 4
1/6/2002 2

And so on.

What I would LIKE would be a chart showing:

WEEK 2002 2003 2004
1 14 xx yy
2 2 xx2 yy2
3

and so on.

I know WEEKNUM returns the week number, but it shows the same value ("1")
for 1/2/2002, 1/2/2003, etc.

So how do I combine the data to give me the week of each year, and then
lay
it over a table??????

This is what you get for being a Lit Major!