Posted to microsoft.public.excel.programming
|
|
calculating ages from dates before 1900
Hi Jason,
Look he
http://spreadsheetpage.com/index.php...unctions_xdate
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"JasonK" wrote in message
...
Thanks in advance once again.
I'm trying to caluculate some ages using a formula recommended in some
earlier posts. I like the format given in three numbers, representing
years, months and days.
I'm using this currently.
=DATEDIF(B1,G1,"y") & " " & DATEDIF(B1,G1,"ym")&" "&
DATEDIF(B1,G1,"md")
my problem is, some of the birthdates are before 1900 and I get the
infamous #VALUE for an answer.
Is there a way to use dates before 1899 or so?
Thanks again,
JasonK
|