How do I get the most current date from a list of dates?

[Guest]

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?

 

[Bondi]

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

 

[Special-K]

=MAX(A1:A1000)

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

 

[Guest]

Worked like a charm!! Thank you SO much!!
Gena

Hi GenaM,

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

=MAX(A1:A10)

Regards,
Bondi