placing people into age groups based on their DOB

  • Thread starter Thread starter JSAUS
  • Start date Start date
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
 
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.
 
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",""})
 
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
 
Back
Top