How do I select and display the oldest date in a column of dates.
J Jacob Skaria Aug 4, 2009 #2 --Sort in ascending order the oldest date will be on top --If you are looking for a formula try the below which will display the smallest date in ColA. Format the formula cell to excel date format =MIN(A:A) If this post helps click Yes
--Sort in ascending order the oldest date will be on top --If you are looking for a formula try the below which will display the smallest date in ColA. Format the formula cell to excel date format =MIN(A:A) If this post helps click Yes
D Dave Peterson Aug 4, 2009 #3 If you sort the range, won't the oldest date be either at the top or bottom of the range?
D Dave Peterson Aug 4, 2009 #4 You could use a formula in a different cell: =min(a1:a10) The oldest date will be the smallest date.
