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'

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10-12-16[/TD]
[TD]11-12-16<strike></strike>[/TD]
[TD]12-12-16<strike></strike>[/TD]
[TD]13-12-16<strike></strike>[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10-12-16<strike></strike>[/TD]
[TD]11-12-16[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]21-12-16[/TD]
[TD]24-12-16[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]01-12-16[/TD]
[TD]05-12-16[/TD]
[/TR]
</tbody>[/TABLE]

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)