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