I'm trying to create a formula to return the earliest date from a column of dates when a date in the same row of an adjacent column is not present.

For example:

Col A Col B
1/1/07 1/2/07
1/15/07
1/31/07 1/28/07
2/15/07
9/15/07

In this case I would want to return 1/15/07. The earliest date in Col A Where Col B hasn't been filled in yet.

I've tried If statments with MIN functions in there. Tried several variations as Array formulas, but have only been succesful so far in returning the minimum date in col A (1/1/07).

Any help much appreciated.

Thanks,

Shred