I have a range of dates on one worksheet e.g 1 Jan 07 - 7 Jan 07 which equals
week 1, 8 Jan 07- 14 Jan 07 which equals week 2 as so on so that all 52 weeks
of the year are covered.

In another sheet I have a date e.g. 3 Jan 07. I want to lookup the range
above and return the value in the week column. Is there a formula that I can
use to do this?

Thanks