Formula to evaluate dates

  • Thread starter Thread starter bigbird98
  • Start date Start date
B

bigbird98

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(A1>25,A1<100,A2>DATE(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
 
Try something along these lines:

=IF(AND(engine>25,engine<100,date>DATE(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
 
Back
Top