selecting the first date in a range of dates

[Guest]

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!

 

[KLZA]

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]

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!

 

[KLZA]

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

 

[T. Valko]

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(ISNUMBER(A1:F1),,0),0)),"")

Format as DATE

 

[Guest]

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

 

[Guest]

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]

See this screencap:

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