Formula for year in school? Freshman, Sophmore
 

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?

Formula for year in school? Freshman, Sophmore
 

What will determine the year? Is it age, birthdate, or what?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Formula for year in school? Freshman, Sophmore
 

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

"Bernard Liengme" wrote:

What will determine the year? Is it age, birthdate, or what?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Formula for year in school? Freshman, Sophmore
 

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?