DATE.DIFF results in French

[Guest]

I am use the DATE.DIFF function to return the time elapsed between two dates
and the results come back in years, months, days. But not in English, the
results say
"1 an 2 mois 3 jour". Is there any way to fix this?

Thanks.

 

[Ron de Bruin]

Hi jenhow

Maybe you use a function from a Add-in ?

Try this one from Norman Harker with the dates in B5 and C5
You can add text yourself

=DATEDIF(B5,C5,"y") & " y " & DATEDIF(B5,C5,"ym") & " m " & DATEDIF(B5,C5,"md") & " d"

 

[Ron Rosenfeld]

I am use the DATE.DIFF function to return the time elapsed between two dates
and the results come back in years, months, days. But not in English, the
results say
"1 an 2 mois 3 jour". Is there any way to fix this?

Thanks.

DATE.DIFF is not an Excel function.

If you are using Longre's morefunc.xll add-in, then you should address your
questions to him directly.


It might be possible to nest that user function in a SUBSTITUTE worksheet
function, though.

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(DATE.DIFF(A1,A2,3),"an","year"),"moi","month"),"jour","day")

However, this will result in months always being plural. You could certainly
test for months being equal to one, and strip off the "s" if it is.

It might be easier to use Excel's DateDif function:

=DATEDIF(A1,A2,"y")&IF(DATEDIF(A1,A2,"y")=1," yr "," yrs ")&
DATEDIF(A1,A2,"ym")&IF(DATEDIF(A1,A2,"ym")=1," month "," months ") &
DATEDIF(A1,A2,"md") & IF(DATEDIF(A1,A2,"md")=1," day", " days")



--ron