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