Thread
:
How can I compute a kids age based on his birthdate
View Single Post
#
3
Ron Rosenfeld
Posts: n/a
On Sun, 3 Jul 2005 10:11:01 -0700, "Coach T" <Coach
wrote:
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
Reply With Quote