L
lindaledb
I am trying to test if an individual's birthdate falls within any of the
given age division date ranges. I would like for it to output the age
division name. Below is a chart showing the current fields on my
spreadsheet. Any suggestions are greatly appreciated.
Beginning 4-H Year 2008
Member's Date of Birth 9/2/2008
Too Young DOB Range 9/1/2008 8/31/2002
Clover Kid DOB Range 9/1/2002 8/31/2000
Junior DOB Range 9/1/2000 8/31/1997
Intermediate DOB Range 9/1/1997 8/31/1994
Senior DOB Range 9/1/1994 8/31/1989
Too Old DOB Range 9/1/1989 8/31/1908
given age division date ranges. I would like for it to output the age
division name. Below is a chart showing the current fields on my
spreadsheet. Any suggestions are greatly appreciated.
Beginning 4-H Year 2008
Member's Date of Birth 9/2/2008
Too Young DOB Range 9/1/2008 8/31/2002
Clover Kid DOB Range 9/1/2002 8/31/2000
Junior DOB Range 9/1/2000 8/31/1997
Intermediate DOB Range 9/1/1997 8/31/1994
Senior DOB Range 9/1/1994 8/31/1989
Too Old DOB Range 9/1/1989 8/31/1908