Lookup date between 2 dates


M

Mouimet

Hi,
First I have a table with 4 columns to lookup
Here part of it
MONTH WEEK# From To
JUN 1 2010-May-30 2010-Jun-05
JUN 2 2010-Jun-06 2010-Jun-12
JUN 3 2010-Jun-13 2010-Jun-19
JUN 4 2010-Jun-20 2010-Jun-26
JUN 5 2010-Jun-27 2010-Jul-03
JUL 1 2010-Jul-04 2010-Jul-10
JUL 2 2010-Jul-11 2010-Jul-17
JUL 3 2010-Jul-18 2010-Jul-24

In another sheet I have data with date
Example:
code amount # Date Month
AMA $200 3 2010-Jul-01 ???????

I need to find the ????
FROM
TO
Meaning: From my list 2010-Jul-01 is between 2010-Jun-27 and 2010-Jul-03
?????? should show "Jun"

I tried with different formula and array, however I can't get the right
result.
I tried with array : =IF((F13>=From)*(F13<=to),1,0)*month
and get #Value instead of JUN

Can you help me please.
Thanks
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top