You can use either one of these formulas. The date of birth is in A1

=INT(YEARFRAC(TODAY(),A1,1)) - Requires the Analysis ToolPac add-in in
versions prior to Excel 2007.

=DATEDIF(A1,TODAY(),"Y") Does not need the Analysis ToolPac

"tjsmags" wrote in message
...
Being a football coach I want to figure out how old a child is AS OF AUG 1
OF
THIS YEAR. I have the childrens' birthdates, so what is the formula to
give
me their ages AS OF Aug 1, 2007?

Thank you.