How can I compute a kids age based on his birthdate

C

Coach T

I need to determine a players "league" age based on his/her birthdate.
League age is computed based on the last birthday occuring before 1 OCT of
the current year. i.e. a Kid born on 30 SEP 99 would be league age 6, while
a kid born on 1 OCT 99 would be league age 5.

Thanx,

Tom
 
D

David McRitchie

Hi Tom,

Do you mean the current calendar year from Jan 1 - Dec 31 use Sept 30

=year(Date(year(today(),10,0) - A2)
which will have a leap year problem

so they shoul work better
=DATEDIF(A2, date(year(totday()), 10, 0), "y")

read more about DATEDIF at Chip Pearson's page
http://www.cpearson.com/excel/datedif.htm
or in Excel 2000 you will find it in HELP but not before or after Excel 2000
has always been available is still available, requires Analysis Toolpak addin
which you stimple activate if the function is not availale.
 
R

Ron Rosenfeld

On Sun, 3 Jul 2005 10:11:01 -0700, "Coach T" <Coach
I need to determine a players "league" age based on his/her birthdate.
League age is computed based on the last birthday occuring before 1 OCT of
the current year. i.e. a Kid born on 30 SEP 99 would be league age 6, while
a kid born on 1 OCT 99 would be league age 5.

Thanx,

Tom

I think this will work:

=YEAR(TODAY())-YEAR(Birthday+92)


--ron
 
P

Paul B

Tom, Typo in David's formula should be, =DATEDIF(A2, date(year(today()),
10, 0), "y")


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

David McRitchie said:
Hi Tom,

Do you mean the current calendar year from Jan 1 - Dec 31 use Sept 30

=year(Date(year(today(),10,0) - A2)
which will have a leap year problem

so they shoul work better
=DATEDIF(A2, date(year(totday()), 10, 0), "y")

read more about DATEDIF at Chip Pearson's page
http://www.cpearson.com/excel/datedif.htm
or in Excel 2000 you will find it in HELP but not before or after Excel 2000
has always been available is still available, requires Analysis Toolpak addin
which you stimple activate if the function is not availale.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

I need to determine a players "league" age based on his/her birthdate.
League age is computed based on the last birthday occuring before 1 OCT of
the current year. i.e. a Kid born on 30 SEP 99 would be league age 6, while
a kid born on 1 OCT 99 would be league age 5.

Thanx,

Tom
 
D

David McRitchie

Thanks Paul, I fixed my other typo before I posted but missed the TODAY()
 
P

Philippe L. Balmanno

David McRitchie said:
Hi Tom,

Do you mean the current calendar year from Jan 1 - Dec 31 use Sept 30

=year(Date(year(today(),10,0) - A2)
which will have a leap year problem

so they shoul work better
=DATEDIF(A2, date(year(totday()), 10, 0), "y")

read more about DATEDIF at Chip Pearson's page
http://www.cpearson.com/excel/datedif.htm
or in Excel 2000 you will find it in HELP but not before or after Excel
2000
has always been available is still available, requires Analysis Toolpak
addin
which you stimple activate if the function is not availale.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Coach T said:
I need to determine a players "league" age based on his/her birthdate.
League age is computed based on the last birthday occuring before 1 OCT
of
the current year. i.e. a Kid born on 30 SEP 99 would be league age 6,
while
a kid born on 1 OCT 99 would be league age 5.

Thanx,

Tom
Try this for fun it will give you a output as follows: 43 years, 4 months,
26 days --- just replace the date or use a cell reference.
=DATEDIF(DATE(1962,2,8),NOW(),"y") & " years, " &
DATEDIF(DATE(1962,2,8),NOW(),"ym") & " months, " &
DATEDIF(DATE(1962,2,8),NOW(),"md") & " days"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top