What is a formula for finding the largest date in a list of dates?

SLD · Oct 22, 2008

I need a fromula for finding the greatest/largest date out of a list of dates
from two columns. Any ideas?

Don Guillett · Oct 22, 2008

Look in the help index for MAX

Niek Otten · Oct 22, 2008

=MAX(A:B)

SLD · Oct 22, 2008

Thanks, That worked.

Niek Otten said:
=MAX(A:B)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Finding a folder with the largest number.	1	Mar 5, 2010
Find values across a row and return a text value from the same column	2	Mar 19, 2013
smallest to largest	9	Jan 1, 2010
First Value in Sorted Column is Not Sorted Properly	3	Jun 26, 2009
finding the second largest number in a list	1	Feb 16, 2005
Excel Help with dates	2	Jul 9, 2019
removing a cell from an array	1	Oct 19, 2008
Cannot sort data	6	Feb 11, 2010

Ask a Question