Try something along these lines:

=IF(AND(engine25,engine<100,dateDATE(2008,7,1)), "test","")

where engine is the cell reference for your engine size and date is
the cell containing the manufacturer date.

Hope this helps.

Pete

On Jul 2, 9:30*pm, 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?