FORMULA TO FIGURE AGE

[tjsmags]

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.

 

[Dave Thomas]

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

 

[Dave Thomas]

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.

 

[tjsmags]

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]

The date of birth is in A1

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]

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

 

[Harlan Grove]

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