Conditional Min function

Hi Excel Experts!

I was hoping you could help me figure out how I could get a min function based on certain conditions to work..

Here is what I have:

25 NO 12/0207
25 maybe 12/03/07
25 YES 12/0607
30 NO 12/04/07
30 YES 12/03/07
25 some 12/0407

I am trying to find a formula that will give me the oldest date from column "c", if both conditions in column a & b are met, if the conditions are not met, then it should find the oldest date where the conditions are met.

So, if column a= "25", and column b does not= "no", then give me the date that corresponds with that row. in this case the answer would be: 12/03/07


Thank you guys soo much!

I've been racking my brain with this one.

OMG!!!! it always is that simple isn't it.

I tried everything but a 2nd if....


Thanks sooo much!! You're the greatest!