Does anyone have any suggestions on how to determine the value within lists?
For example,
[1]
There is a given date in cell A1, 06-Jun without concerning year, I would
like to determine the value within column C, it should return 6 in cell A2,
because 06-Jun is equal to or larger than 05-Jun and less than 21-Jun.
[2]
There is a given date in cell A1, 05-Jun without concerning year, I would
like to determine the value within column C, it should return 6 in cell A2,
because 05-Jun is equal to or larger than 05-Jun and less than 21-Jun.
[3]
There is a given date in cell A1, 07-Mar without concerning year, I would
like to determine the value within column C, it should return 24 in cell A2,
because 07-Mar is equal to or larger than 05-Mar and less than 21-Mar.

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric

There are list under columns
[b] [C]
21-Mar 1
05-Apr 2
20-Apr 3
05-May 4
21-May 5
05-Jun 6
21-Jun 7
07-Jul 8
23-Jul 9
07-Aug 10
23-Aug 11
07-Sep 12
22-Sep 13
08-Oct 14
23-Oct 15
08-Nov 16
22-Nov 17
07-Dec 18
21-Dec 19
05-Jan 20
20-Jan 21
04-Feb 22
19-Feb 23
05-Mar 24

VLOOKUP function should do the trick (approximate match)... HOWEVER... column B should be sorted from OLDEST TO NEWEST.