Outputing Weeks Of Year And Comparing Date Ranges

Looking the best way to create a dynamic table to display the following, using COLDFUSION MX, with this question i am more concerned in working out the query for the date compares:  -

         Display Weeks Of Fiscal Year (April to March) as table header
         Perform Query To Count Total Costs Of Items That Fall In Each Week
         Week Starts On Monday and ends on Sunday ?, flexible with this...
         

eg.. Year 2005
                          Table Header (Week Numbers for 2005 Starting From April)

                        02nd April  | 09th April | 16th April | 23rd April | 30th April |07th May   etc...
Category1          2000            4500            etc..
Category2          3000            5000            etc..
Category3          4000            6000            etc..
etc...

QUERY
Some type of count(*) but who do i compare with the 52 weeks in the specified FISCAL Year ??

ITEM Table
ITEMID                      PK
ITEMNAME                VARCHAR(50)
ITEMCATEGORYIDFK  FK
COST                       INT

ITEM Categorys TABLE
ITEMCATEGORYID      PK
ITEMCATEGORYNAME VARCHAR(50)

Any advice on how to accomplish this would be much appreciated

JT