rhiannon458
New Member
- Joined
- Sep 16, 2014
- Messages
- 4
Hi,
I would like to check if a certain date is included in a list of date ranges (e.g. of bills) but could not find the right way to do so..
<tbody>
</tbody>
I need a formula which checks if the date in A1 is in any range of D:E - in this case it would be in the range of 02.06.2014-28.06.2014 (D2:E2) and therefore in cell B1 it should say "True"/1 or the like.
Could you please help me?
rhia
I would like to check if a certain date is included in a list of date ranges (e.g. of bills) but could not find the right way to do so..
A | B | C | D | E | |
Dates | In Range? | From | To | ||
1 | 13.06.2014 | True | Bill 1 | 20.02.2014 | 23.03.2014 |
2 | 27.06.2014 | True | Bill 2 | 02.06.2014 | 28.06.2014 |
3 | 05.08.2014 | True | Bill 3 | 01.08.2014 | 05.08.2014 |
4 | 02.04.2014 | False |
<tbody>
</tbody>
I need a formula which checks if the date in A1 is in any range of D:E - in this case it would be in the range of 02.06.2014-28.06.2014 (D2:E2) and therefore in cell B1 it should say "True"/1 or the like.
Could you please help me?
rhia