Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •