Date lies between

  • Thread starter Thread starter Kash
  • Start date Start date
K

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
 
'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
 
You havent mentioned any thing about the names in your initial post...and so
its not clear to me..
 
Still it is unclear..Elaborate how your data is arranged so that someone here
could help.
 
Back
Top