J
jrchappell75
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?
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?