IF AND formula with dates

[Kim25]

Hi All,

Could someone kindly help with my formula?


<TABLE style="WIDTH: 390pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=520 border=0><COLGROUP><COL style="WIDTH: 120pt; mso-width-source: userset; mso-width-alt: 5120" width=160><COL style="WIDTH: 54pt" span=5 width=72><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD class=xl231 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 120pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=160 height=22>1/05/11</TD><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 270pt; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent; mso-ignore: colspan" width=360 colSpan=5>=IF(AND(A3>="01/04/11",A3<="30/6/11"),20,0)</TD></TR></TBODY></TABLE>

The highlighted number in red is cell A3. The formula keeps returning a zero instead of 20.

 

[Ganjin]

=if(and(a3 >= date(2011,4,1),a3 <= date(2011,6,30)),20,0)

 

[Kim25]

Awesome, works perfectly. Thankyou very much.