I have the following challenge:

I have a table containing date ranges for weeks, and a week code telling me if this is an A week, a B week, or a C week, like this:

WeekCode FromDate ToDate
A 1/30/2011 2/5/2011
B 2/6/2011 2/12/2011
C 2/13/2011 2/19/2011
D 2/20/2011 2/26/2011
A 2/27/2011 3/5/2011
B 3/6/2011 3/12/2011
C 3/13/2011 3/19/2011
D 3/20/2011 3/26/2011

The user enters in two dates here:
Fromdate= 2/1/2011
ToDate = 2/28/2011

I need the following to be populated:
A WEEK ENDS ON: datethatislookedup
B WEEK ENDS ON: datethatislookedup
C WEEK ENDS ON: datethatislookedup
D WEEK ENDS ON: datethatislookedup

I need to know the formulas that go in the "datethatislookedup" cells
The table of dates I have is for the entire year and is in order.