I an building a worksheet for baseball registration. I need to compare the
Birthdate to the date we use to determine playing age in a division. I have
attempted to use the =datedif(date1,date2(), "interval") where
date1=birthdate, date2=playing age date, Interval="y". The result is #ref!
error.

For example: We have said the players age on 05/01/2006 is the playing age
for the league. I want to compare the birthdate to 05/01/2005, and get an age
value.

I would like to be able to update it yearly so that next year I can siply
change the 05/01/2006 date to 05/01/2007 and recalculate the age value.

Is this possible?

Am I going about this the wrong way?

What am I doing wrong?