software

What formula would i need to use to find the most recent date in a row of
dates?


Trapp

Try rthe formula
=MAX(A1:A13)--
mudraker
------------------------------------------------------------------------
mudraker's Profile: www.excelforum.com/member.php...foamp;userid=2473
View this thread: www.excelforum.com/showthread...hreadid=515579That depends on the row of dates.

If the dates will be greater than today, then you probablly need the MIN
date.
If the dates will be less than today, then you'll want the MAX date.
If they could be greater OR less tnan today and you want the date closest to
today, you probably need the MIN of the absolute values of the differences
between the dates and today.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Trappquot; wrote:

gt; What formula would i need to use to find the most recent date in a row of
gt; dates?

Thank you both. This is a great forum for someone who has a lot to learn
about this powerful tool. Thank you for the time.

quot;mudrakerquot; wrote:

gt;
gt; Trapp
gt;
gt; Try rthe formula
gt; =MAX(A1:A13)
gt;
gt;
gt; --
gt; mudraker
gt; ------------------------------------------------------------------------
gt; mudraker's Profile: www.excelforum.com/member.php...foamp;userid=2473
gt; View this thread: www.excelforum.com/showthread...hreadid=515579
gt;
gt;