Formula to determine Little League age

narniaz87

New Member
Hello, I need help creating a formula for my Little League's player database
I would like this Formula to look at the Child's birthdate and be able to tell what league age they are

For children born on or before April 30, 2006 their league age is how ever old they are on April 30th of that year. So a child born April 30, 2006 would be league age 9
Little league then changed the requirments so everyone born after May 1, 2006 their league age is how ever old they are on December 31st of that year. So a child born December 31, 2006 is also 9. Anyone born in 2007 is 8. 2008 is 7 and so on.
If anyone can help me out on this one it'd be much appreciated! Thank you.

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

gaz_chops

Well-known Member
Try,

Where A1 is the Birthdate.
=YEAR(TODAY())-YEAR(A1)

ukmikeb

Well-known Member
Hi

Welcome to MrExcel Forum.

Try :-
PHP:
``=DATEDIF(A2,DATE(YEAR(TODAY()),12,31)-244*(A2<DATE(2006,5,1)),"y")``

where the birthdate is in A2.

hth

Last edited:

Replies
29
Views
542
Replies
2
Views
319
Replies
4
Views
796
Replies
3
Views
556
Replies
3
Views
386

1,195,650
Messages
6,010,925
Members
441,573
Latest member
Goronvir

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back