determining the greater of three or more numbers

's Computer Specifications

I have three dates in three seperate cells. Can I create a formula in a
fourth cell comparing the dates and returning the greater of the three?

Example...

cell 1 cell 2 cell 3
1/1/09; 4/7/09; 3/18/09; What would the formula be to return 4/7/09?

using Excel 2003

's Computer Specifications

=MAX(A1:A3)
If the 3 cells are A1:A3

Regards,
Stefi

â€žDarrylâ€ ezt Ã*rta:

> I have three dates in three seperate cells. Can I create a formula in a
> fourth cell comparing the dates and returning the greater of the three?
>
> Example...
>
> cell 1 cell 2 cell 3
> 1/1/09; 4/7/09; 3/18/09; What would the formula be to return 4/7/09?
>
> using Excel 2003

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
the greater of 2 numbers	=?Utf-8?B?S2FyZW4=?=	Microsoft Excel New Users	4	16th Feb 2006 06:35 PM
How can I superscript numbers greater than 3?	=?Utf-8?B?Q2FzZXliYXk=?=	Microsoft Excel Misc	2	23rd Apr 2005 05:04 PM
greater than replace numbers	=?Utf-8?B?bWph?=	Microsoft Excel Worksheet Functions	1	23rd Mar 2005 06:41 PM
Re: factorial of numbers greater than 170	Jon Skeet [C# MVP]	Microsoft Dot NET Framework	0	7th Sep 2004 08:52 PM
Re: factorial of numbers greater than 170	Imran Koradia	Microsoft Dot NET Framework	0	7th Sep 2004 08:51 PM