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

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