placing people into age groups based on their DOB

[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

 

[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.

 

[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",""})

 

[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