Formula to determine Little League age

[narniaz87]

Hello, I need help creating a formula for my Little League's player database
I would like this Formula to look at the Child's birthdate and be able to tell what league age they are

For children born on or before April 30, 2006 their league age is how ever old they are on April 30th of that year. So a child born April 30, 2006 would be league age 9
Little league then changed the requirments so everyone born after May 1, 2006 their league age is how ever old they are on December 31st of that year. So a child born December 31, 2006 is also 9. Anyone born in 2007 is 8. 2008 is 7 and so on.
If anyone can help me out on this one it'd be much appreciated! Thank you.

 

[gaz_chops]

Try,

Where A1 is the Birthdate.
=YEAR(TODAY())-YEAR(A1)

 

[ukmikeb]

Hi

Welcome to MrExcel Forum.

Try :-

=DATEDIF(A2,DATE(YEAR(TODAY()),12,31)-244*(A2<DATE(2006,5,1)),"y")

where the birthdate is in A2.

hth