Using ranges within if statements? Help please!

[Shelle]

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'

	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!

 

[HackSlash]

I think you need to add MIN and MAX to your IF.

If it's less than the MAX(B4:B6) and it's greater than the MIN(A4:A6)