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

[imogenbosmith]

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!

[Kevin@Radstock]

Hi imogenbosmith

Perhaps using the VLOOKUP, without a small sample sheet it is hard to say.
Have a look these 2 sites for more info on the VLOOKUP.

http://office.microsoft.com/en-gb/ex...101862716.aspx

http://www.myonlinetraininghub.com/e...ulas-explained