Assuming Engine size is in cell A1 and Manufacturer's dat is in cell A2...

=IF(AND(A125,A1<100,A2DATE(2008,7,1)),"OK","Yuck !")
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"bigbird98" wrote:

I'm trying to figure out a formula that will evaluate dates such as: If
engine size is greater than 25 and less than 100 AND the manufacturer date is
after 7/1/2008; then test.

Any ideas?