Age (as of today) Formula

[gymwrecker]

Need help with a formula to calculate an individuals age as of today. This is what I have

A1=1957/07/07
A2=today()
A3= ? (age in years)

Please advice...

 

[tc88]

Need help with a formula to calculate an individuals age as of today. This is what I have

A1=1957/07/07
A2=today()
A3= ? (age in years)

Please advice...

Excel Workbook
	A	B	C
1	7/7/1957	7/13/2011	54
Sheet1

Excel 2010

Cell Formulas
Range	Formula
B1	=TODAY()
C1	=DATEDIF(A1,B1,"Y")

Where "Y" is the denomination you want your date difference in ("Y","M","D"--years/months/days)

 

[gymwrecker]

Thanks!!! Formula working perfect!!!!