| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
| Formula to calculate someone's exact age | Excel Discussion (Misc queries) | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How do I calculate exact difference between two dates in y,m,d. | Excel Worksheet Functions | |||
| How to get the Excel to calculate the exact date from a given date | Excel Worksheet Functions | |||
Threaded Mode
