I am not to good at Excel, but here is my question

I have a field (i.e. say cell J6) with the birthdate (date field) of
person and I can calculate their age from that no problem.

I want to be able to calculate their school year. so someone who i
going to be 12 before the 1 September 2005 will be in year 7 at thi
time. Someone who is going to be 13 before 1 September 2005 will b
year 8 and so on.

For a year 7 their birhdate can be any time between the 1 Septembe
1992 and the 31 August 1993 and a year 8 birthdate can be between
September 1991 and 31 August 1992. I want to be able to have shown o
screen and in the printed form their school year and to be able to us
this field to sort them in to school year.

Does anyone have the right formula that I could use, I just cannot see
to be able to figure this one out.

Help would be appreciated

regards

Davi

--
David
-----------------------------------------------------------------------
DavidL's Profile: http://www.excelforum.com/member.php...fo&userid=1682
View this thread: http://www.excelforum.com/showthread.php?threadid=32017