Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup date between 2 dates
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup date between 2 dates
Check your previous post...
If this post helps click Yes --------------- Jacob Skaria "Mouimet" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup between dates | Excel Discussion (Misc queries) | |||
Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions | |||
Lookup a date between other dates | Excel Worksheet Functions |