daddylonglegs wrote:
If your date of birth is in A2 you can use this formula to give the
correct category. Note: it will give different results on 1st Jan 2007

=LOOKUP(DATEDIF(A2,DATE(YEAR(TODAY()),5,15),"y"),{ 0,9,11,13,15,17,19},{"8&under","9-10","11-12","13-14","15-16","17-18","too
old"})


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=550843


Thank you very much Daddy. It worked like a charm!