Blank cell

[Memar]

I just want to check if a certain date is between a range of days. This is the formula that I have. It gives me the answer YES/NO. In addition, I want the cell A42 to be blank when there is no data in cell A29. Currently it says no even if there is no data in A29. I don't what that to confuse people with the NO answer we get with the date is out of the range of days. Would you please let me know how to modify the formula.

=IF(AND(A29>=$B$38,A29<=$C$38),"YES","NO")

A42 <TABLE style="WIDTH: 86pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=115 x:str><COLGROUP><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4205" width=115><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #ffcc99; WIDTH: 86pt; HEIGHT: 13.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 height=18 width=115>YES</TD></TR></TBODY></TABLE>


Thanks for you time and help.

 

[VoG]

Try

=IF(A29="","",IF(AND(A29>=$B$38,A29<=$C$38),"YES","NO"))

 

[Memar]

Thanks it works.