Looking at dates for greater than and less than

[FryGirl]

For some reason, I can't figure out the logic here

I need to compare A2 against the dates in row 1. If the date in row 1 is greater than A2, but less then the next date then place a 1.

Since A2, 19-Oct-16 is greater than D1, but less than E1, then D2 should be a 1.

Data Range

	A​	B​	C​	D​	E​
1​	​	3-Oct-16​	10-Oct-16​	17-Oct-16​	24-Oct-16​
2​	19-Oct-16​	0​	0​	1​	0​

 

[godsaaint]

Insert in B2 and fill right/down:

=+IF(AND($A2>B$1,$A2<c$1),"1","0")

EDIT: the formula keeps getting cut. <c$1),1,0)< html=""></c$1),1,0)<></c$1),"1","0")

 

[sitewolf]

<c$1),"1","0")
likely just have to put quotes around your formula so the forum software isn't seeing it as a formula?


</c$1),"1","0")

 

[Tetra201]

This?

=IF(AND($A$2 > B$1,$A$2 < C$1),1,0)<c $1),1,0)<="" html=""></c>

 

[AliGW]

<c$1),"1","0")
likely just have to put quotes around your formula so the forum software isn't seeing it as a formula?

No, just spaces around the < character, which otherwise it doesn't like.


</c$1),"1","0")

 

[FryGirl]

This?

=IF(AND($A$2 > B$1,$A$2 < C$1),1,0)<c $1),1,0)<="" html=""></c>

Hmmmm, not sure what happened, thought I tried that, but your solution works great. Thanks

 

[Tetra201]

Glad it worked for you.

 

[FryGirl]

Just figured out what I was doing wrong. I had the references reversed.

I used =IF(AND(B$1>=$A$2,C$1<$A$2),"♦","") that's why I was getting horrible results