I help out at a kids rugby club and am using Excel to record the kids details. We need to know which year they are in at school and I 'm trying to make the Excel 2003 spreadsheet work this out. I have one column calculating their age on current day but can't develop a formula that calculates school year because that runs from 1/Sept/xx to 31/Aug/xx. eg my Son is in year 1 DOB 25/03/02. I am trying to make the s/s future proof in that it can be used for future years without alteration. Any ideas? Anybody?