View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JSAUS JSAUS is offline
external usenet poster
 
Posts: 2
Default placing people into age groups based on their DOB

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