On Fri, 20 May 2005 08:26:02 -0700, JIM.H.
wrote:

Hello,
I have a birthday column with YYYYMMDD format and I need to create an age
column. How can I do that?
Thanks,
Jim.

With your birth date in A1:

=DATEDIF(TEXT(A1,"0000\/00\/00"),TODAY(),"y")

will give you the age in years.


--ron