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