Prev: Excel template similar to MS Money less investments?
Next: Variable refers to a workbook
From: Kash on 4 Jun 2010 09:57
I have 2 date column in sheet "DB" and I need to find if the date entered in
sheet1 lies between these dates..

That is for Example - if I enter dates 12-May to 15-May it should say "True"
or what ever else "false"

Its should check the entire column and give the result.


From To
12-May 15-May
25-May 26-May
28-May 01-Jun
05-Jun 08-Jun
From: Jackpot on 4 Jun 2010 10:07
'If there is only 1 query date then try the below with query date in cell E1

=SUMPRODUCT((DB!A1:A5<=E1)*(DB!B1:B5>=E2))<>0

If it is a date range; then try the below with E1 and E2 as start/end dates..
=SUMPRODUCT((DB!A1:A5<=E1)*(DB!B1:B5>=E2))<>0


"Kash" wrote:

> I have 2 date column in sheet "DB" and I need to find if the date entered in
> sheet1 lies between these dates..
>
> That is for Example - if I enter dates 12-May to 15-May it should say "True"
> or what ever else "false"
>
> Its should check the entire column and give the result.
>
>
> From To
> 12-May 15-May
> 25-May 26-May
> 28-May 01-Jun
> 05-Jun 08-Jun
From: Kash on 4 Jun 2010 11:26
I agree I had not mentioned.. but any solution now?
From: Jackpot on 4 Jun 2010 11:41
Still it is unclear..Elaborate how your data is arranged so that someone here
could help.

"Kash" wrote:

> I agree I had not mentioned.. but any solution now?
 | 
Pages: 1
Prev: Excel template similar to MS Money less investments?
Next: Variable refers to a workbook