Dreamster,

How is "Completed" indicated?

Perhaps, array enter (enter using Ctrl-Shift-Enter) something like

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

HTH,
Bernie
MS Excel MVP


"Dreamstar_1961" wrote in message
...
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