excel formulas

Help!
I need help with an excel worksheet - I need a formula for some testing that I am doing on kindergartners (have about 100). The sheet will have name and other demographics, but what I need is a formula that will calculate age in years and months. I need to subtract the date of testing from the date of birth to yield an age for class placement. This age for placement needs to be in years and months. (i.e.. a child may be 6 years old, but after testing (according to his score) will be 5 years 3 months which would place him in a certain class).

The sheet will have columns for name, test given, birthday and test date (the test date could be any date [today was the first day of testing] tomorrow will be second date, and as new students enroll there would be another test date. Data would look something like:
Last First Test DOB Test Age In Yrs
Name Name Given Date & Mos


Is this doable?

 

You will certainly need to keep the DOB in 3 seperate fields.
YYYY / MM / DD
and the the class fields also separate
YYYA / MMA

YYYA = (Yearnow() -YYYY) specified for each line/child
MMA = (Monthnow()-MM) specified for each line/child

or you could add these fields with one decimal place after dividing MMA by 10, so that 5.6 =5 years and 6 months old
Note that the values will change as you open the worksheet
in a new month.
regards