How to work out school year groups from dates of birth or age (in months and days)

imogenbosmith

New member
Joined
Jan 9, 2013
Messages
1
Reaction score
0
Points
0
Hi,

I am in need of a bit of help and can't seem to find an answer that I understand anywhere!

So I have a group of child data, I have their dates of birth and then have the formula to work out their ages in months and days so I have all of that. From this information I then want to automatically have the year group in which they are in at school, starting with nursery, reception, to year 1, 2, 3 etc up to year 12 and 13. I think this will have to be done from their ages? I'm not sure. I want this to be updated every year automatically.

If anyone knows how to do this and can pass on their pearls of wisdom it would be much appreciated!

Thank you!
 
Back
Top