View Single Post
  #3   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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