What about
enter this in C1
=($B$1-A1)/365.25

B1 is 1-9-11
A1 is date of birth
change format in column C to number with 1 decimal place.


"D G" wrote in message
...
I need to convert a date of birth to age. However, I need to base it
on Sept 1, 2011. I need to know how old (years only) that person is
on that date. Does anyone know how to do this. Why is September 1,
2011 so important. It allows me to determine if they are eligible(too
young or too old) to play a sport.