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.