Help: Formula for calculating Baseball League Age?

[Brent]

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

 

[David Biddulph]

To find the age at 30th April of the current year, try
=IF(A1="","",DATEDIF(A1,DATE(YEAR(TODAY()),4,30),"y"))

 

[Brent]

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

 

[Dave Peterson]

Chip Pearson has some very nice notes:
http://www.cpearson.com/excel/datedif.htm

 

[David Biddulph]

DATEDIF is the awkward one, as Microsoft have left it out of Excel's help
for some inexplicable reason.
Details can be found at http://www.cpearson.com/excel/datedif.htm

For other Excel functions [including DATE() and YEAR()], your best bet is
Excel's help function which will explain the syntax.
Most of the help entries also have a "see also" link to help you with
similar functions that may be useful in the future.