find date is between date ranges

[sauk304]

Hi.


i would like to find the date between the date ranges.

the date is in cell A1,

the Start Date is in cell B1:B100 and End Date is in C1:C100. how do i use excel if the date within the ranges then it will return a value

example, i want to search date 18.03.2012 between 01.03.2011 to 31.03.2011.

Find Date	Start Date	End Date	Result
18.03.2011 <colgroup><col width="86"></colgroup><tbody> </tbody>	01.03.2011 <colgroup><col width="99"></colgroup><tbody> </tbody>	31.03.2011 <colgroup><col width="74"></colgroup><tbody> </tbody>	yes
28.01.2011 <colgroup><col width="86"></colgroup><tbody> </tbody> <colgroup><col width="86"></colgroup><tbody> </tbody>	01.03.2011 <colgroup><col width="99"></colgroup><tbody> </tbody>	31.03.2011 <colgroup><col width="74"></colgroup><tbody> </tbody>	no
27.01.2011 <colgroup><col width="86"></colgroup><tbody> </tbody>	01.03.2011 <colgroup><col width="99"></colgroup><tbody> </tbody>	31.03.2011 <colgroup><col width="74"></colgroup><tbody> </tbody>	no
22.03.2011 <colgroup><col width="86"></colgroup><tbody> </tbody>	01.03.2011 <colgroup><col width="99"></colgroup><tbody> </tbody>	31.03.2011 <colgroup><col width="74"></colgroup><tbody> </tbody>	yes

<tbody>
</tbody>

 

[Robert Mika]

=IF(AND(A2>=B2,A2<=C2),"yes","no")

 

[cyrilbrd]

Also: =IF(A2=MEDIAN(A2:C2),"Yes","No")