Thanks you for responding Peo

If you meant for me to add this to the sumproduct formula, it failed. If
you meant for me to use as is, it returns the min date without considering
the criteria.

What I am looking for is: 'What is the earliest date (ignor blanks) in
this range (column B) which meets the specifed criteria (Column A, Row n).
If there are no blanks I can use:

sumproduct(MIN(--(PO1=A2)*Issued1)) and this returns the latest date, where
PO1 is my criteria range and Issued1 are the dates. Is there something I can
do to this formula to obtain the minimum date in the range?

Thanks

Gwynneth


"Peo Sjoblom" wrote:

=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