Date lies between

[Kash]

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

 

[Jackpot]

'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

 

[Jackpot]

You havent mentioned any thing about the names in your initial post...and so
its not clear to me..

 

[Kash]

I agree I had not mentioned.. but any solution now?

 

[Jackpot]

Still it is unclear..Elaborate how your data is arranged so that someone here
could help.