returning a value if a date falls between two dates

**chillangella** · 09-28-2009, 06:30 AM

Hello,

I need help in returning a value if the date entered falls on a specified range. Please refer to the attached file.

I want Week to return the Week Number where the date i entered falls.

Example: if the Date entered is 01/20/09, Week should return the value 4.

**DonkeyOte** · 09-28-2009, 06:44 AM

Perhaps

F9: =INDEX(A2:A12,MATCH(E9,B2:B12))

**chillangella** · 09-28-2009, 06:48 AM

wow! thats exactly what I need.

Thank you very much

**DonkeyOte** · 09-28-2009, 06:51 AM

No problem... based on your sample file you could dispense with the INDEX and just use the MATCH if the week numbers commence from 1 and increment by 1 each time, ie:

F9: =MATCH(E9,B2:B12)