Suppose you have DOB in A1
For current year, enter 8/31/2008 in B1
Enter this in C1
==DATEDIF(A1,B1,"y")

This will give you age in years as on 8/31/2008

Now you can check this in D1 like this
=IF(C1=5,"KG",C1-4)
assuming you do not have kids who are not in school

otherwise
=IF(C14,IF(C1=5,"KG",c1-4),"Too young to be in school)

You can get a formula to give you 8/31/2008 if you do not want to enter a
date once a year :-)

"Bek" wrote:

From a list of dates of birth I need to show what school year they are in
today, but have it so it is always correct in the future too.

I can caculate their current school year using a vlookup table of dates of
birth between Sept and August and the relevent school year, but come
September 2009 this will be wrong.

i.e. if born 30th January 1996 today you will be in school year 8.
If I check the spreadsheet in January 2010 I need it to be telling me you
are now in year 9.

School year runs from 1st September to 31st August.

Any help much appreciated!