Q: age column
 

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

=INT((TODAY()-DATE(LEFT(A1,4),MONTH(MID(A1,5,2)),DAY(RIGHT(A1,2) )))/365)


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

That formula will have errors when the date is near a person's birthday due
to leap year issues.


Try

=DATEDIF(startdate,enddate,"Y") for years

See XL help for more information on this formula.

HTH

PC

"N Harkawat" wrote in message
...
=INT((TODAY()-DATE(LEFT(A1,4),MONTH(MID(A1,5,2)),DAY(RIGHT(A1,2) )))/365)


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

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

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.

My previous formula works for US regional settings. I'm not sure about other
countries.


--ron