Thread: How do I get the most current date from a list of dates?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Special-K Special-K is offline
external usenet poster
  
Posts: 1
Default How do I get the most current date from a list of dates?

=MAX(A1:A1000)

Could try that.
If you insert a new date within the range ie between rows 1 and 1000
the function should adjust accordingly


--
Special-K
------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562458

Reply With QuoteReply With Quote