Posted to microsoft.public.excel.worksheet.functions
|
|
Calculate 'exact' age in EXCEL
What is your question?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Zanny Garbett" wrote in message ...
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
|