I need to fiind the oldest date of an entry depending on the status of the
case.

A B C
Canada Open 6/25/07
Mexico Open 6/16/07
Brazil Open 6/1/07
Canada Open 6/19/07
Canada Closed 6/2/07

I need to be able find the oldest open date for Canada which would be 6/19/07
according to this example.