Convert Resource Profile from Days to Weeks

This is similar to a another issue i had, but i couldn't adapt it to work for my new issue.
http://www.excelforum.com/excel-form...nd-column.html

I have a table of names as the row headers and the column heads are dates (1-Dec-12) for a given time period. I need to copy this data into another worksheet that will be based on weeks. The previous answer was:

Please Login or Register  to view this content.

I tried to modify it using WEEKNUM, but it was erroring out:

Please Login or Register  to view this content.

Daily to Weekly.xlsx