=if((1/1/2010) between A1 and B1, 1,0)??

[DucDuc]

I want to know if a date is between the start A and finish B but this always comes up false..

<TABLE style="WIDTH: 243pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=324 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 49pt; mso-width-source: userset; mso-width-alt: 2332" width=66><COL style="WIDTH: 146pt; mso-width-source: userset; mso-width-alt: 6912" width=194><TBODY><TR style="HEIGHT: 13.2pt" height=18><TD class=xl22 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" align=right width=64 height=18 x:num="40179">01/01/10</TD><TD class=xl22 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 49pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=right width=66 x:num="40193">01/15/10</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 146pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=194>{=IF((2010/1/2)>B4<C4,1,0)}</TD></TR></TBODY></TABLE>


Is it possible to get teh result I want, is there a better function or formula?

thanks for having a look

 

[RichardMGreen]

If your date in question is in C1 with your start/finish dates in A1/B1 respectively, in D1 you can use:-
=if(and(c1>=A1,c1<=b1),True,False)

 

[Comfy]

=IF(AND(A2<=DATE(2010,1,2),B2>=DATE(2010,1,2)),"Yes","No")

I've used the date Function as it isn't clear in your formula what the format is, whether it's the 1st of Feb or the 2nd of Jan that you are evaluating.