Condition Date between a range of dates

[D87RFM]

Hello,

I'm looking at the same formula since months and I can't solve it, maybe you can help me.

I want to create a condition that should be something like that:

If (data on cell A) is bigger or equal than (date cell B) and small or equal than (data cell C) so (new condition), if not "0".

Using ">=" and "<=" is not working Can you please help me?

Thanks!

Ex: target date: 31/01/2016

Validity period: 01/01/2015 - 01/05/2016

Because 31/01/2016 is between the validity period the second condition should copy the value, otherwise not.

 

[Special-K99]

=if(and(a1>=b1,a1<=c1),true,false)

 

[D87RFM]

I tried this one, but for some reason, the second condition is affected when is not supposed to.

=IF(AND($BH$1>=V36,$BH$1<=X36),IF($T36="CONTRACT",VLOOKUP($B36,'Cons DATA'!$V:$AX,15,FALSE)/1000,VLOOKUP($B36,'Cons DATA'!$AZ:$BN,15,FALSE)/1000),0)

The condition when is not contract returns automatically zero