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!
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
Bookmarks