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

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

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

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

Brent wrote:

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




--

Dave Peterson

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.
--
David Biddulph

"Brent" <brentwalker at walkerzone dot com wrote in message
...
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