Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating age when person born before 1900
Calculating a person's age works using an undeclared function in Excel
(datedif) as in =DATEDIF(A1,NOW(),"y")&" Y, "& DATEDIF(A1,NOW(),"ym")& " M, " & DATEDIF(A1,NOW(),"md") & " D" But this doesn't work if the date in A1 is before 1900 and if the date is not formatted 01-Jan-06 (for example). Any ideas as to how to get around this elegantly without going through laborious additions of 100's of years etc. I want to use it in conjunction with census dates hence the reason to go back beyond 1900. This problem may be why datedif is not a documented function. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mileage Claim Formula | New Users to Excel | |||
How to avoid "update links" startup prompt? | Excel Discussion (Misc queries) | |||
is 1900 a Leap Year? | Excel Discussion (Misc queries) | |||
Calculating Age of person on admission date | Excel Discussion (Misc queries) | |||
D Sum or SumIF | Excel Worksheet Functions |