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


"bob the bolder" <bob the wrote in message
...
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?