Hello

School years run from 1 - 14 with Reception and Nursery prior to that,
however, the people I'm using will be from approx year 8 onwards.

N - 4th birthday between 1st Sept and 31st Aug
R - 5th birthday between 1st Sept and 31st Aug
1 - 6th birthday between 1st Sept and 31st Aug
2 - 7th birthday between 1st Sept and 31st Aug
3 - 8th birthday between 1st Sept and 31st Aug
4 - 9th birthday between 1st Sept and 31st Aug
5 - 10th birthday between 1st Sept and 31st Aug
6 - 11th birthday between 1st Sept and 31st Aug
7 - 12th birthday between 1st Sept and 31st Aug
8 - 13th birthday between 1st Sept and 31st Aug
9 - 14th birthday between 1st Sept and 31st Aug
10 - 15th birthday between 1st Sept and 31st Aug
11 - 16th birthday between 1st Sept and 31st Aug
12 - 17th birthday between 1st Sept and 31st Aug
13 - 18th birthday between 1st Sept and 31st Aug
14 - 19th birthday between 1st Sept and 31st Aug

Year 14 is the last.

cheers


"Ron Rosenfeld" wrote:

On Tue, 20 Jan 2009 07:03:06 -0800, 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!

How old does someone have to be to enter school? What is the cutoff date?
--ron