HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
 

I need to create a formula to calculate age as of 04-30-10. Can anyone help
me? I am using Excel 2007.

Answer: HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
 

To calculate age as of a certain date in Excel 2007, you can use the

Code:

---

DATEDIF

---

function. Here are the steps:

1. In a blank cell, enter the birthdate of the person you want to calculate the age for. For example, if the birthdate is 01/01/1990, enter it as 01/01/1990.
2. In another blank cell, enter the current date as of which you want to calculate the age. For example, if you want to calculate the age as of 04/30/2010, enter it as 04/30/2010.
3. In a third blank cell, enter the following formula:
   Code:

   ---

   =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months, "&DATEDIF(A1,B1,"md")&" days"

   ---

4. Replace A1 with the cell reference of the birthdate and B1 with the cell reference of the current date that you entered in steps 1 and 2.
5. Press Enter to calculate the age.

The formula will display the age in years, months, and days. For example, if the birthdate is 01/01/1990 and the current date is 04/30/2010, the formula will display "20 years, 3 months, 29 days".

HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
 

=DATEDIF(A1,B1,"y")

with variable date in A1 and today's date in B1

Look he

http://www.cpearson.com/excel/datedif.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BB" wrote in message
...
I need to create a formula to calculate age as of 04-30-10. Can anyone help
me? I am using Excel 2007.

HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
 

<today's date

Make that your "certain date"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message
...
=DATEDIF(A1,B1,"y")

with variable date in A1 and today's date in B1

Look he

http://www.cpearson.com/excel/datedif.aspx

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BB" wrote in message
...
I need to create a formula to calculate age as of 04-30-10. Can anyone
help
me? I am using Excel 2007.

This was extremely helpful for me as well. Thanks!