Calculating age.
 

Help, i need to figure out how to put in numerical form the age of this
person.

I have theire birth date January 15, 2000 i need to find the age.

i tried today()-birthday but it gives me another date form?

Suggestions/


--
pinehead
------------------------------------------------------------------------
pinehead's Profile: http://www.excelforum.com/member.php...o&userid=31721
View this thread: http://www.excelforum.com/showthread...hreadid=516774

Calculating age.
 

hi!
assuming the date of birth is in A1

try this!

=DATEDIF(A1,TODAY(),"Y")&"YEARS,"&DATEDIF(A1,TODAY (),"YM")&"MONTHS,"&DATEDIF(A1,TODAY(),"MD")&"DAYS. "

-via135





pinehead Wrote:
Help, i need to figure out how to put in numerical form the age of this
person.

I have theire birth date January 15, 2000 i need to find the age.

i tried today()-birthday but it gives me another date form?

Suggestions/


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=516774