Formula for year in school? Freshman, Sophmore

[Guest]

I volunteer with a youth group on the weeknds. I need to create a
spreadsheet that will track their grade level in school. (Freshman, Sophmore
etc.) Is there a formula I can use that will help me with this?

 

[Bernard Liengme]

What will determine the year? Is it age, birthdate, or what?

 

[Guest]

If I could use a birthdate as the determiner taht would be great.

 

[Bernie Deitrick]

Bob,

With their birthday in cell A1, try:

=CHOOSE(DATEDIF(A1,DATE(2006,11,30),"y")-14,"Freshman","Sophomore","Junior","Senior")

this assumes that Dec 1 is the break date for deciding which class a child
is in...

HTH,
Bernie
MS Excel MVP