View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi Bondi is offline
external usenet poster
 
Posts: 94
Default How do I get the most current date from a list of dates?


GenaM wrote:
Our students have to make up any class time they miss. I am working on a form
to keep up with how much time they have made up for each absence. I will have
a list of dates, at the bottom of my form I need it to pull the most current
date from the list of dates. Example:
7/1/06
7/2/06
7/5/06

7/5/06 (the most current date)
Is this possible?


Hi GenaM,

Maybe on solution would be (if your list of dates is in A1:A10) to use

=MAX(A1:A10)

Regards,
Bondi