formula between data reqd [SOLVED]

[webmax]

I have data from A to E Cell like the Name and followed by the Expiry date of product

i want the formula in F Cell that if the date of A from Date 1 to Date 4 is between 01 apr 2013 to 30th Sep 2013 the answer should come as "Yes"

[pre]

Name	Date 1	           Date 2	Date 3          Date 4
A	05-Jun-12	05-Jun-15	07-May-13	08-Feb-19
B	04-Aug-11	07-Aug-13	06-Oct-00	07-Sep-02
C	05-Sep-13	08-Mar-20	08-Sep-05	07-Sep-10
D	07-May-13	07-Jun-18	08-Feb-13	31-Mar-13

[/pre]

 

[Faseeh]

Hi Webmax,


Can you post the sample output for your posted data so that i can cross check it.


Regards,

 

[webmax]

hi kindly find below the sample file


https://www.dropbox.com/s/gchewiizf6017tr/betweendates.xlsx?m

 

[Faseeh]

Webmax,


With Start and end date in H1 and I1, try this:

=IF(SUMPRODUCT((B2:E2>=$H$1)*(B2:E2<=$I$1)*1)>0,"Yes","No")

..and drag down.


Regards,

 

[webmax]

hi thanks it is working fine

 

[Faseeh]

You are welcome!