Need date formula for before 1900.

[serge]

I need to know what would be the solution , if there is one, for calculating age of a person that is born before 1900 ?

A1 : 12/2/1863

B1 : 12/13/1930

C1 : =DATEDIF(A1,B1,"Y")&" Years "&DATEDIF(A1,B1,"YM")&" Months "&DATEDIF(A1,B1,"MD")&" Days"

Is there a solution ? Thank you... Serge.

 

[MrKowz]

Excel does not natively have that compatability without using some nasy formulas, but thankfully there is an Add-in out there for this.

Check out John Walchenbach's XDate: Extended Date Functions Add-In

 

[shg]

You could add 400 to each year:

A1: 12/2/2263

B1: 12/13/2330

 

[serge]

Thank you for the help, I will look into it.

Regards... Serge.

 

[Rasm]

This may help

http://www.exceluser.com/explore/earlydates.htm

 

[serge]

Thanks Rasm for the link.