Retrieve earliest date from a row

[barnetap]

How can I retrieve the earliest date (mm/dd) from a row (I-Q)? To complicate matters there are non-date entries (ie N/A and TBD) intersperced throughout the row. Thanks for any help.

 

[Steve Hartman]

Since dates are actually decimal numbers all you need to do is use =min(range) where range is your data and you will get the earliest date. format this cell with whatever you date format you want.
This message was edited by Steve Hartman on 2002-02-21 13:07

 

[Aladin Akyurek]

On 2002-02-21 13:00, barnetap wrote:
How can I retrieve the earliest date (mm/dd) from a row (I-Q)? To complicate matters there are non-date entries (ie N/A and TBD) intersperced throughout the row. Thanks for any help.

If I:Q does not have any error values like #N/A, use:

=MIN(I1:Q1)

otherwise array-enter:

=MIN(IF(NOT(ISERROR(I1:Q1)),I1:Q1))

To array-enter a formula, you need to hit control+shift+enter, not just enter.

Aladin