Formula for year in school? Freshman, Sophmore

B

bob the bolder

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

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
 
Top