=MIN(IF(Date<"",Date))

entered with ctrl + shift & enter


will find the earliest date that is not blank


--


Regards,


Peo Sjoblom



"Gwynneth" wrote in message
...
I am trying to find the minimum date in a range, which contains blanks.
subject to a criteria. As the range contains blanks, these are currently
picked up as the min date and display 00-Jan-00.

Is there a way of using sumproduct and excluding/ignoring blank cells?

PO1 is my range for criteria and Created1 is my range on the dates I am
using in the following formula

=Sumproduct(MIN(--(PO1=A2)*Created1))

Gwynneth

--
Gwynneth