Calculate the number of days between two dates

[Ron Rosenfeld]

Ron., you're very very kind but be damned the day I choose to use
Excel in my language (italian)!...
Now I'm getting crazy in finding the equivalents of "SUBSTITUTE",
"DATE", "MID", "MATCH" to make your formulas work in my Excel 2007
italian.

I would the name of the person in Microsoft that decided to remove the
support of english in the formula language in not-english versions of
Excel!
Please someone teach him the meaning of the word "compatibility".

Ah, I did not realize that was an issue.

Of course, you must be aware that US English uses the comma as a separator, and
most non-English versions use the semicolon.

Also, this URL may be useful: http://cherbe.free.fr/traduc_fonctions_xl97.html

SUBSTITUTE SOSTITUISCI
DATE DATA
MID STRINGA.ESTRAI
MATCH CONFRONTA

--ron

 

[Luca Villa]

Ron, thanks for the table with traslations!

Now I tried "=--SOSTITUISCI(SOSTITUISCI(A1,"-"," ",1),"-",", ")" and
it worked!!
I'm impressed about it! How does it know the names of the months?

 

[Ron Rosenfeld]

Ron, thanks for the table with traslations!

Now I tried "=--SOSTITUISCI(SOSTITUISCI(A1,"-"," ",1),"-",", ")" and
it worked!!
I'm impressed about it! How does it know the names of the months?

Glad it worked.

The function doesn't need to know the names of the months, but Excel does.

Excel won't recognize:

Oct-29-07 as a date, but it will recognize:
Oct 29, 07 as a date.

The SUBSTITUTE function changes the first "-" into a <space>, and the second
"-" into a <comma><space>.

If you use the Tools/Formula Auditing/Evaluate Formula option, you can see the
changes "step-by-step"
--ron

 

[Luca Villa]

Thanksssss Ron! you're a real genius!!!