View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zanny Garbett Zanny Garbett is offline
external usenet poster
 
Posts: 1
Default Calculate 'exact' age in EXCEL

Try this with:

[A1] = date of birth;
[B1] = Date of death;

=DATEDIF(A1,B1,"y")&"y,"&DATEDIF(A1,B1,"ym")&"m,"& DATEDIF(A1,B1,"md")&"d"

Should work OK

Regards
Zanny

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com/default.aspx?ref=ng