If the dates are in ascending order:

=IF(COUNT(A1:F1),MIN(A1:F1),"")

Format as DATE

If the dates are random:

=IF(COUNT(A1:F1),INDEX(A1:F1,MATCH(TRUE,INDEX(ISNU MBER(A1:F1),,0),0)),"")

Format as DATE

--
Biff
Microsoft Excel MVP


"shoun2me" wrote in message
...
Hi,
This will be easy for you, I'm sure.

In a cell, I need to show the first date out of a row of dates, when the
first date could be in the 1st 2nd, or nth column.

Any help would be appreciated!