HOW TO CALCULATE AGE AS OF A CERTAIN DATE?

BB · Feb 4, 2010

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

Niek Otten · Feb 4, 2010

=DATEDIF(A1,B1,"y")

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

Look here:

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

Niek Otten · Feb 4, 2010

<today's date>

Make that your "certain date"