Calendar date before 1900.

[serge]

Hi,
I'm trying to calculate the time between 2 date that are before 1900, I have the first date in B1 and the end date in C1, I'm wondering if someone would have an excel formula that will calculate the year, month, day in cell D1 ?

I have this one but doesn't do the job !!! only after 1900.

=DATEDIF(B1,C1,"Y")&" Ans "&DATEDIF(B1,C1,"YM")&" Mois "&C1-EDATE(B1,DATEDIF(B1,C1,"M"))&" Jours"

Thank you.

 

[Shortmeister1]

Excel can't read dates before 1900. The figure in column B is text.

One way round it would be to add 100 years to the dates in column B and C, convert them to date serial numbers, and then subtract one from the other. It's a bit of a hack, but it will work.

 

[Joe4]

Here is a detailed explanation of a similar method with examples: Deal With Dates Before 1900

 

[Scott Huish]

Check out my post (#4) here.

Not displaying dates before 1900

im trying to get dates Before 1900 to display the dates that are meeting the criteria. but as its before 1900 it dont display, but if its 1900 onwards it has no problem displaying. all help appreicated. hope the pic helps.

www.mrexcel.com

 

[serge]

Thank you guys really appreciate your input.