Calculate the number of days between two dates

  • Thread starter Thread starter Luca Villa
  • Start date Start date
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".
Click to expand...

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
 
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, 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?
Click to expand...

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
 
Back
Top