Age Function?

[hcaoc7]

How can I take a cell with a date in it (A students birthday) and in another cell automatically show how old that student is? (2/18/03 in cell A1 and show 8 in cell A2)

Thanks

 

[njimack]

=datedif(a1,today(),"y")

 

[VoG]

Try

=DATEDIF(A1,TODAY(),"y")

 

[hcaoc7]

Thanks, to both of you however, I am getting an error with that formula. When I enter it in I get the error message I click ok and the "y" part of the formula is highlighted. I am using Excel 2003, should have mentioned that in the first place.

 

[hcaoc7]

Never mind! It works great it was an error on my part.

Thanks!

 

[Nalani]

And if you want to get really fancy, try:

Excel Workbook
	A	B
1	DOB	Age
2	2/18/2003	Age is 8 Years, 8 Months and 17 Days
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B2	="Age is "&DATEDIF(A2,TODAY(),"y")&" Years, "&DATEDIF(A2,TODAY(),"ym")&" Months and "&DATEDIF(A2,TODAY(),"md")&" Days"