Excel Formula Function - Formula to find the oldest date out of a range of dates listed
Originally Posted in our Excel Help Forum
Got any Excel/VBA Questions? Free Excel Help
ktaylor wanted a formula method for finding the oldest (lowest) date out of a list of dates in a column.
Egad suggested the following solution providing the date range was in cells A1:A30
=SMALL(A1:A30,1) will return the smallest (oldest) date or number.
=SMALL(A1:A30,2) will find the second smallest….and so on
Epidemic suggested using one of the MIN MAX and MEDIAN functions.
An example would be
=MIN(A1:A30)
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
