selecting the first date in a range of dates
 

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!

selecting the first date in a range of dates
 

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?

selecting the first date in a range of dates
 

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!

selecting the first date in a range of dates
 

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

selecting the first date in a range of dates
 

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!

selecting the first date in a range of dates
 

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?

selecting the first date in a range of dates
 

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!

selecting the first date in a range of dates
 

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!