Help instruction Datedif incorrect

%3CLINGO-SUB%20id%3D%22lingo-sub-2404093%22%20slang%3D%22en-US%22%3EHelp%20instruction%20Datedif%20incorrect%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2404093%22%20slang%3D%22en-US%22%3E%3CP%3EDo%20not%20know%20eho%20to%20contact%20regarding%20this%20so%20I%20will%20try%20posting%20it%20here.%20I%20recently%20noticed%20that%20the%20help%20section%20on%20the%20DATEDIF-function%20is%20incorrect.%20This%20is%20the%20description%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DDATEDIF(startdate%2Cenddate%2C%22m%22)%20-%20for%20calculation%20of%20months%20between%20two%20set%20dates.%20This%20function%20does%20not%20work%2C%20the%20correct%20function%20is%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DDATEDIF(startdate%3Benddate%3B%22m%22)%3CBR%20%2F%3E%3CBR%20%2F%3EWith%20this%20function%2C%20the%20correct%20result%20is%20given.%20Just%20a%20heads-up%20for%20Microsoft%2C%20you%20might%20want%20to%20change%20the%20instruction%2C%20I%20am%20from%20sweden%20so%20I%20do%20not%20know%20if%20this%20applies%20to%20all%20languages.%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20Regards%3CBR%20%2F%3EChristoffer%20Ekman%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2404093%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Do not know eho to contact regarding this so I will try posting it here. I recently noticed that the help section on the DATEDIF-function is incorrect. This is the description:

=DATEDIF(startdate,enddate,"m") - for calculation of months between two set dates. This function does not work, the correct function is:

=DATEDIF(startdate;enddate;"m")

With this function, the correct result is given. Just a heads-up for Microsoft, you might want to change the instruction, I am from sweden so I do not know if this applies to all languages.

Kind Regards
Christoffer Ekman

1 Reply

@SEKRIEKM 

The arguments of a function must be separated by the system's list separator character.

The documentation has been written for English-speaking countries; they use point as decimal separator and comma as list separator.

Most continental European countries, including Sweden, use comma as decimal separator and semicolon as list separator.

Apparently the Swedish version of the documentation has not been adapted correctly.

You can select File > Feedback in Excel, and click Send a Frown.