Birthdate before 1900.

[serge]

Hi,
I have those 2 formulas.
This one calculate birthdate.
=DATEDIF(B8,C8,"Y")&" Ans "&DATEDIF(B8,C8,"YM")&" Mois "&C8-EDATE(B8,DATEDIF(B8,C8,"M"))&" Jours"

This one the days remaining before the birthdate.
=DATEDIF(TODAY(),EDATE(B9,(YEAR(NOW())-YEAR(B9)+1)*12),"ym")&" Mois "&DATEDIF(TODAY(),EDATE(B9,(YEAR(NOW())-YEAR(B9)+1)*12),"md")&" Jours"

I'm looking for a formula that will calculate birthdate before 1900 is that possible ?

Thank you.

 

[AhoyNC]

Maybe one of these links will help.
A VBA solution from MicroSoft and another one from Mr Excel.

How to calculate ages before 1/1/1900 in Excel - Office
Deal With Dates Before 1900

 

[serge]

Thank you AhoyNC for the links, really appreciate it.