Minimum and maximum date lookup

[Guest]

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?

 

[Guest]

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.

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?

 

[T. Valko]

Just use the MIN/MAX functions.

Earliest date:

=MIN(A1:A10)

Latest date:

=MAX(A1:A10)