Excel 2007 : =IF formula to identify "Yes" or "No" if between two dates

Originally Posted by Rizzu

I want a formula that basically does both of these simultaneously:
=IF(C2>A2,"Yes","No")
=IF(C2<B2,"Yes","No")
Any help is appreciated , thank you!

try

=IF(AND(C2>A2,C2<B2),"Yes","No")

or (depend on your need)

=IF(OR(C2>A2,C2<B2),"Yes","No")