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.
<tbody>
</tbody>
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 | ||||
<colgroup><col width="86"></colgroup><tbody> </tbody> |
<colgroup><col width="99"></colgroup><tbody> </tbody> |
<colgroup><col width="74"></colgroup><tbody> </tbody> | yes | ||||
<colgroup><col width="86"></colgroup><tbody> </tbody> |
<colgroup><col width="99"></colgroup><tbody> </tbody> |
<colgroup><col width="74"></colgroup><tbody> </tbody> | no | ||||
<colgroup><col width="86"></colgroup><tbody> </tbody> |
<colgroup><col width="99"></colgroup><tbody> </tbody> |
<colgroup><col width="74"></colgroup><tbody> </tbody> | no | ||||
<colgroup><col width="86"></colgroup><tbody> </tbody> |
<colgroup><col width="99"></colgroup><tbody> </tbody> |
<colgroup><col width="74"></colgroup><tbody> </tbody> | yes |
<tbody>
</tbody>