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.

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.

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.

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.

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.

I said to replace the TODAY() function in the formulas with "8/1/2007".
Using TODAY() calculates the age as of today.

So replacing TODAY() with "8/1/2007" the formulas become:

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

=DATEDIF(A1,"8/1/2007","Y") Does not need the Analysis ToolPac



"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.

"tjsmags" wrote...
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?

Pro or college coaches wouldn't need this, so you seem to be a high school
coach. Don't you have enough fingers & toes?

Seriously,

=DATEDIF(DateOfBirth,"8/1/2007","Y")