View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Kolonia[_2_] Brian Kolonia[_2_] is offline
external usenet poster
 
Posts: 3
Default League age chart

I have a large number of youth base ball players listed in a roster;

Player name birth date
john doe 3/5/2001
mike smith 7/31/2001...

And an age eligiblality chart on another sheet:
Month
League Age
5 6 7 8 9 10 11 12 1 2 3
4
2002 2002 2002 2002 2002 2002 2002 2003 2003 2003 2003 2003 5
2001 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 6
2000 2000 2000 2000 2000 2000 2000 2000 2001 2001 2001 2001 7
1999 1999 1999 1999 1999 1999 1999 1999 2000 2000 2000 2000 8
1998 1998 1998 1998 1998 1998 1998 1998 1999 1999 1999 1999 9
1997 1997 1997 1997 1997 1997 1997 1997 1998 1998 1998 1998 10
1996 1996 1996 1996 1996 1996 1996 1996 1997 1997 1997 1997 11
1995 1995 1995 1995 1995 1995 1995 1995 1996 1996 1996 1996 12
1994 1994 1994 1994 1994 1994 1994 1994 1995 1995 1995 1995 13
1993 1993 1993 1993 1993 1993 1993 1993 1994 1994 1994 1994 14
1992 1992 1992 1992 1992 1992 1992 1992 1993 1993 1993 1993 15
1991 1991 1991 1991 1991 1991 1991 1991 1992 1992 1992 1992 16
1990 1990 1990 1990 1990 1990 1990 1990 1991 1991 1991 1991 17
1989 1989 1989 1989 1989 1989 1989 1989 1990 1990 1990 1990 18

I would like to add a colum that would automaticaly grab the correct age
from the chart :
Palyer name birth date leauge age
john doe 3/5/2001 ?
mike smith 7/31/2001 ?

Is this easily done?
Thank you BJK