See this screencap:

http://img530.imageshack.us/img530/4793/lookupfp6.jpg

--
Biff
Microsoft Excel MVP


"shoun2me" wrote in message
...
T.Valko,

Thanks for the answer, but I'm afraid I didn't post the question very
good.

I'm trying to fill in the correct starting date in a form for the care of
my
patients. I have a worksheet that lists each patient the days of the
week,
and the hours that we were there. In the example below I'd need to fill
in
"7/30/07" for patient 1, and "7/31/07" for patient 2. Each patient has
their
own worksheet that I use to print out their paticular form.
7/30/07 7/31/07 8/1/07 8/2/07 8/3/07 8/4/07
patient1 3 7 9

patient2 5 24

patient3 4 10 9

"T. Valko" wrote:

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!