I'm back needing more help.

On a workbook i have, we record the customers details in columns A - E.

In column J is the name of the staff member looking after that customer.

In column I is the date work was received for that customer.

Each member of staff has about 300 customers each. What I want to do is on sheet 3 (named stats) I want to be able to enter the staff members name, and find the oldest date that they have to their name.

I have tried =MIN(IF((Sheet1!J2:J1300="MICHELLE"),Sheet1!I2:I1300)) but that returns 0-Jan-1900 as not all cases have work outstanding. I have tried formatting cells and that doesnt work.

Can anyone help?

Thanks