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

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?

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

=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

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

"Bondi" wrote:

>
> 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
>
>

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

"Bondi" wrote:

>
> 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
>
>