How do I get the most current date from a list of dates?
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
|