Minimum and maximum date lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
=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?
 
Back
Top