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!

On Aug 1, 3:56 pm, shoun2me
wrote:
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!

By first date do you mean oldest or latest?

KLZA,

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

"KLZA" wrote:

On Aug 1, 3:56 pm, shoun2me
wrote:
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!

By first date do you mean oldest or latest?

On Aug 1, 3:56 pm, shoun2me
wrote:
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!

Simple solution would be to hilight al of your dates and right-click
on the status bar and select MIN for oldest date or MAX for latest
date. Cheers!

Go to that cell type =MAX(A2:A4) - where A2:A4 is the range of cells
you will be using (can be any range).

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!

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!

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!