If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create Formula for calculating Little League Age...
Some of you may be aware, Little League has changed the date in which
they use to calculate the players age for the spring season beginning the spring of 2006. I would like to be able to enter in the birthdate of the player and then the formula calculate the players Little League age. Little League rulebook states that for any player in the Majors division who will attain the age of 9 years old before April 30 and who will not attain the age of 13 before April 30 of the year in question shall be eligible to compete in Little League Majors Division. This means that a child who will be 13 years old on May 1st or later is eligible for play in the Majors; a player who will be 13 years old on April 30th or earlier will not be eligible for the Majors division but expected to play at the next higher division. Another way of saying this is if you are 13 on 5/10/2005 then you will be considered as a player in the Majors division. If you are 13 on 4/25/05 then you will not be eligible to play in Majors but moved up to Juniors. I am trying to create a formula that would help calculate this "league" age. Here is where I have gotten so far. A1 Birthdate LLAge A2 4/30/93 =IF(A2="","",DATEDIF(A2,NOW(),"y")) Basically the first part looks for empty cells and leaves them blank without having to look at an entire spreadsheet with a bunch of "0" age kids. The second part is where I am having difficulty. I am trying to use the DATEDIF function by taking the birthdate and subtracting it from the NOW() function and presenting the year. I guess I need some other sort of IF statement to figure out the before 4/30 birthday and the after 4/30 birthday. Any ideas on making this easier? thanks. |
#2
|
|||
|
|||
On 20 Sep 2005 14:54:05 -0700, "Brent" wrote:
Some of you may be aware, Little League has changed the date in which they use to calculate the players age for the spring season beginning the spring of 2006. I would like to be able to enter in the birthdate of the player and then the formula calculate the players Little League age. Little League rulebook states that for any player in the Majors division who will attain the age of 9 years old before April 30 and who will not attain the age of 13 before April 30 of the year in question shall be eligible to compete in Little League Majors Division. This means that a child who will be 13 years old on May 1st or later is eligible for play in the Majors; a player who will be 13 years old on April 30th or earlier will not be eligible for the Majors division but expected to play at the next higher division. Another way of saying this is if you are 13 on 5/10/2005 then you will be considered as a player in the Majors division. If you are 13 on 4/25/05 then you will not be eligible to play in Majors but moved up to Juniors. I am trying to create a formula that would help calculate this "league" age. Here is where I have gotten so far. A1 Birthdate LLAge A2 4/30/93 =IF(A2="","",DATEDIF(A2,NOW(),"y")) Basically the first part looks for empty cells and leaves them blank without having to look at an entire spreadsheet with a bunch of "0" age kids. The second part is where I am having difficulty. I am trying to use the DATEDIF function by taking the birthdate and subtracting it from the NOW() function and presenting the year. I guess I need some other sort of IF statement to figure out the before 4/30 birthday and the after 4/30 birthday. Any ideas on making this easier? thanks. It seems that what you need to know is the age of the person on 30 April in the current year. Then you can construct your various IF statements. The age of a person, in years, on 30 April of "this" year is given by the formula: =DATEDIF(Date_of_Birth,DATE(YEAR(TODAY()),4,30),"y ") --ron |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I create and save a formula for text fields? | Jason | General Discussion | 2 | June 21st, 2005 10:20 PM |
In two workbooks, how do I create a formula that will look at a o. | socaldave469 | General Discussion | 1 | April 22nd, 2005 10:01 PM |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
I need a formula to do a league | mviltan | General Discussion | 1 | August 16th, 2004 04:43 PM |
Create formula with variables | Kelly | Worksheet Functions | 4 | January 13th, 2004 10:38 PM |