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?

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?

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?