How to find Dates????

coccio · Apr 24th, 2002, 06:38 AM

I looking for a formula that can look into a range of cells which lists dates in excel and find the most current date and display it in another cell. Is there anyway to do that?

IML · Apr 24th, 2002, 06:43 AM

if you dates are in A1:A10 and you want to display the latest date in B1, put this in B1

=max(A1:a10)

and format as date.

This will work as long as the range only contains dates or text (no other numbers)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 06:38 AM	#1
coccio Board Regular Join Date: Mar 2002 Posts: 137	I looking for a formula that can look into a range of cells which lists dates in excel and find the most current date and display it in another cell. Is there anyway to do that?

Apr 24th, 2002, 06:43 AM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	if you dates are in A1:A10 and you want to display the latest date in B1, put this in B1 =max(A1:a10) and format as date. This will work as long as the range only contains dates or text (no other numbers)