Return the Earliest Date

[Impos2004]

Hi,

I'd really appreciate some help with, what will probably prove to be a pretty simple problem.

I have a list of dates in column A, next to a list of statuses in column B, as follows....

01/01/2012 New
01/01/2013 Open
05/05/1978 Closed
22/04/2015 New

The dates are stored as dates, not text.

I would like to write a formula that will return the earliest date that corresponds with a value of "New". Please can someone help?

Thanks

 

[Aladin Akyurek]

...

I am more lost now than before when I thought it was pure witchcraft!

Any non-zero number gets thru because 1/(1/non-zero number) >> non-zero number; a zero number causes #DIV/0! which triggers IFERROR to return value_if_error, a user indicated return value.