Determine what language Office runs
If you are from a non-english speaking country, users do run Excel in different languages. I.e. a german company, some users run in German and others in English.
When using the function TEXT(Date, "expression"), in German it should state: TEXT(Dat...