Ok this really makes me mad. You solved my problem in 4 minutes when I have
been working at this for several hours. Doesn't really make me mad, but
foot, I spent 2 hours when you solved it in 4 minutes! :)

Would you please help me understand the DateDif portion and everything
after?

Thanks alot
Brent



"David Biddulph" wrote in message
...
To find the age at 30th April of the current year, try
=IF(A1="","",DATEDIF(A1,DATE(YEAR(TODAY()),4,30)," y"))
--
David Biddulph

"Brent" <brentwalker at walkerzone dot com wrote in message
...
Ok, I have been playing with excel for quite a while now and have been
able to calculate a persons age. But, I have been unable to calculate a
persons baseball league age. Here is the rule for league age: "whatever
age a player is on April 30, will be their age for the current baseball
season.

As an example, if my son is born on 5/10/1993 he is eligible to play in
the baseball 13U (stands for baseball 13 year old division). This is
because on April 30, my son is still 13 years old.

However the old rule for league age was "whatever age a player is on July
31, that will be their league age". In this case, my son would now be
required to play in the 14U division as he would be age 14 on July 31st.

I have been trying to come up with a formula that would take a persons
birthdate and produce the league age automatically.

The formula I have been using for a persons "normal" age is:
=IF(A1="","",DATEDIF(A1,NOW(),"y")) where A1 contains a persons birthdate
(5/10/93). Obviously this would produce a cell value of 13.

Any help is appreciated.

Thanks,
Brent
brentwalker at walkerzone dot com