Minimum and maximum date lookup
 

I want to make a cell display the earliest, and/or latest date in a list of
dates in a column. That way I can have a cell show the date range of a list
of dates from the earliest to the latest. I'm a rookie at Excel, I know just
enough to get me into trouble. Can anyone help me with this?

Minimum and maximum date lookup
 

Let's say your range is A1 to A16

In the cell you want to display the minimum, put =MIN(A1:A16)
In the cell you want to display the maximum, put =MAX(A1:A16)

Whilst dates don't look as if they'll work, excel actually stores them as
code numbers and therefore a formula which will work on normal numbers should
do the job.

Hope this helps.

"Michael Peace" wrote:

I want to make a cell display the earliest, and/or latest date in a list of
dates in a column. That way I can have a cell show the date range of a list
of dates from the earliest to the latest. I'm a rookie at Excel, I know just
enough to get me into trouble. Can anyone help me with this?

Minimum and maximum date lookup
 

=TEXT(MIN(A1:A29),"dd-mm-yyyy")&" - "&TEXT(MAX(A1:A29),"dd-mm-yyyy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Michael Peace" <Michael wrote in message
...
|I want to make a cell display the earliest, and/or latest date in a list of
| dates in a column. That way I can have a cell show the date range of a list
| of dates from the earliest to the latest. I'm a rookie at Excel, I know just
| enough to get me into trouble. Can anyone help me with this?

Minimum and maximum date lookup
 

Just use the MIN/MAX functions.

Earliest date:

=MIN(A1:A10)

Latest date:

=MAX(A1:A10)

--
Biff
Microsoft Excel MVP


"Michael Peace" <Michael wrote in message
...
I want to make a cell display the earliest, and/or latest date in a list of
dates in a column. That way I can have a cell show the date range of a
list
of dates from the earliest to the latest. I'm a rookie at Excel, I know
just
enough to get me into trouble. Can anyone help me with this?