Calculating age.

P

pinehead

Help, i need to figure out how to put in numerical form the age of thi
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
 
V

via135

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
 
Top