Mary-Lou,
If the data that you initially posted is the exact data you are using, then
you need to correct that first. You have the wrong year for these dates
show - 04 instead of 05 and 05 instead of 06.
31-Dec-04 6-Jan-05 11
7-Jan-05 13-Jan-05 12

NickHK

"Mary-Lou" wrote in message
...
I tried this (with fingers crossed) but still received the exact same
results
where the 20 records from Dec 18 to Jan 6 still incorrectly return a value
of
week 12. I'm going to try redoing everything from scratch and see what
happens.

"Waxaholic" wrote:

This will work correctly if you change the "Range Lookup" value from 1
to "TRUE". It worked for me here.