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"

--
Regards Ron de Bruin
http://www.rondebruin.nl



"jenhow" wrote in message ...
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.