Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=MIN(IF(B2:B6<"completed",A2:A6))

Format as DATE

Biff

"Dreamstar_1961" wrote in message
...
the formula only returned 00/01/00, what I'm after is to display the next
lowest date, not completed

A2 2/3/06 B2 completed
A3 3/3/06 B3 completed
A4 4/3/06 B4 running
A5 5/3/06 B5 ruuning
A6 6/3/06 B6 completed

it is to return 4/3/06 as that is not completed I tryed using the formula
with the small formula but don't know how to advance it to the next number


"Teethless mama" wrote:

=MIN(IF(B1:B100="Completed",A1:A100,0))


"Dreamstar_1961" wrote:

Hi
what I'm after is a formula to return the oldest date not completed
currently I'm using the min command but that returns the oldest