It's not real clear what you want. My interpretation is:

Find the earliest date where the status is not "done" and return the
corresponding action, date and status.

If that's what you want try these formulas:

Try this array formula** for the "action" entered in cell E2:

=INDEX(A2:A5,MATCH(MIN(IF(C2:C5<"done",IF(ISNUMBE R(B2:B5),B2:B5))),B2:B5,0))

This formula entered in F2 and copied across to G2 for the date and status:

=VLOOKUP($E2,$A2:$C5,COLUMNS($A:B),0)

Format the date cell as DATE

This formula entered in cell H2 for the difference in dates based on today:

=TODAY()-F2+1

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Ixtreme" wrote in message
oups.com...
In column A I have several actions listed. In column B, I have for
some of those actions some due dates while in column C I have a status
field.
Something like this:

ColumnA ColumnB ColumnC
---------------------------------------------------
Action A 14-08-2007 done
Action B 26-08-2007 Pending
Action K
Action Z 29-08-2007 Awaiting

the data is not sorted.

What I would like is to find the earliest date in column B where
status is not equal to a predefined range of items)
The result should be the action to be done, it's status and the number
of days plus or minus compared to today's date.

Rng = "Open", "Pending", "Awaiting"

Result: Action B, Pending, 2 days

Thanks!!