I have a contact management system that tracks students and their information. I have a field that is a drop down list and the students current grade can be chosen. I want to have another field that auto updates and will show their expected graduation year or "class of" year. So for example if I chose that one student was in 1st grade the class of field would auto populate to show that their class of year was 12 years from the current date. How do I do this?

Thanks Again For all the help!

Erik

You could use a calculation field for this - but I believe you need not only the "current grade", but also the date at which the current grade is "current", in order to make the calculation.

Thanks for the response. I just dont know what functions i need to be using in this calculation

It's not a question of functions, but of input. It's been a while since I've been to school, but I believe the general calculation is:

YearEnrolled - GradeEnrolled + YearsOfProgram + GradesRepeated - GradesSkipped + 1

Example:

Adam enrolled in 2000 into the 3rd grade of a 12-year school; assuming he did not skip/repeat any grades, his expected graduation year =

2000 - 3 + 12 + 1 = 2010