The date of birth is in A1

"tjsmags" wrote in message
...
I'm confused...I thought you said A1 should be 8/1/07...so where do I put
the
child's birthdate to find out how old they'll be on 8/1/07?

"Dave Thomas" wrote:

To calculate the age as of 8/1/2007, replace the TODAY() function in the
formulas I sent with: "8/1/2007". Note the date must be in quotes.


"Dave Thomas" wrote in message
. net...
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.