placing people into age groups based on their DOB


J

JSAUS

I am trying to classify people into age groups in Excel based on their DOB.
U8 1-Jan-2003 to 31-Dec-2006
U10 1-Jan-2001 to 31-Dec-2002
U12 1-Jan-1999 to 31-Dec-2000
U14 1-Jan-1997 to 31-Dec-1998
U16 1-Jan-1995 to 31-Dec-1996
U18 1-Jan-1993 to 31-Dec-1994
U20 1-Jan-1991 to 31-Dec-1992
Senior before 31-Dec-1990
 
Ad

Advertisements

B

Bob Phillips

Create a table of values, column 1 is the start date, column 2 is the
category, in reverse date order (first is 31-Dec-1990, and so on), and just
use VLOOKUP with a final parameter of TRUE.
 
J

Jacob Skaria

Try the below formula with DOB in cell A1

=LOOKUP(YEAR(A1),{0,1991,1993,1995,1997,1999,2001,2003,2007},
{"Senior","U20","U18","U16","U14","U12","U10","U8",""})
 
Ad

Advertisements

J

JSAUS

This works - but I forgot to mention that if filed (say B1) contains either
"Volunteer" or "Non playing member", then this should be placed into the
field instead of an age group
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top