Hello,
I work at a preschool and we're doing a summer camp ranging ages 5-11. I have a list of 80 kids with their birthdays. I've created a formula that tells me their age based on date of birth.
This list is ever changing and I wanted to make a formula that will divide and count the kids into 4 age groups and look something like this:
5-6:
7-8:
9-10:
11:
Any help would be greatly appreciated.
I work at a preschool and we're doing a summer camp ranging ages 5-11. I have a list of 80 kids with their birthdays. I've created a formula that tells me their age based on date of birth.
This list is ever changing and I wanted to make a formula that will divide and count the kids into 4 age groups and look something like this:
5-6:
7-8:
9-10:
11:
Any help would be greatly appreciated.