Check date falls between mentioned date

[nirmalachr]

Dear Forum,

I would like to check the date(stored as date in column j) falls after 01/05/2015, before 30/06/2015 and i= "sanctioned" then it should calculate f*1 else 0 for this i am using the below formula but i am not able to get the true value even though date falls between the mentioned date and i = sanctioned.

=IF(AND(J3>=01/05/2015,J3<=30/06/2015,I3="SANCTIONED"),F3*1,0)

Kindly help me out.

Thanks in advance.

 

[MarcelBeug]

In general you can't enter dates JUST like that in a formula. Try DATE(2015,5,1) and DATE(2015,6,30).

 

[gaz_chops]

Or

=IF(AND(J3>=datevalue("01/05/2015"),J3<=datevalue("30/06/2015"),I3="SANCTIONED"),F3*1,0)