Hi!
I need a formula to go in each of the cells in row 2 which checks the above cell date in row 1 and gives a yes or no answer based on looking at the contents of columns A and B.
E.g. if the date in D1 is between any of the dates in column A and the consecutive cell in column B, return 'Yes'
<tbody>
</tbody>
<tbody>
</tbody>
So, logically (but not correctly)
=IF(AND(D1>=A4:A6,D1<=B4:B6),"Yes","No")
Thanks!
I need a formula to go in each of the cells in row 2 which checks the above cell date in row 1 and gives a yes or no answer based on looking at the contents of columns A and B.
E.g. if the date in D1 is between any of the dates in column A and the consecutive cell in column B, return 'Yes'
D | E | F | G | |
1 | 10-12-16 | 11-12-16<strike></strike> | 12-12-16<strike></strike> | 13-12-16<strike></strike> |
2 | Yes | Yes | No | No |
<tbody>
</tbody>
A | B | |
4 | 10-12-16<strike></strike> | 11-12-16 |
5 | 21-12-16 | 24-12-16 |
6 | 01-12-16 | 05-12-16 |
<tbody>
</tbody>
So, logically (but not correctly)
=IF(AND(D1>=A4:A6,D1<=B4:B6),"Yes","No")
Thanks!