Forum Discussion
Solved
Unexpected error while trying to use DATEDIF
Hi, I am trying to use the DATEDIF function but I get an unexpected error. I've read many online examples and I'm doing everything correctly. I type "=DATEDIF(", click on the cell with the first...
Perhaps you shall use semicolons instead of commas as delimiter =DATEDIF(H6; ...
Do you use comma as decimal separator? If so, you should use semi-colon ; to separate the arguments of a function. For example:
=DATEDIF(H6;J6;"m")
HansVogelaarNo, I use "." for decimal separator but the ";" worked...
Every examples I've seen, including Excel 2016 Help use "," with this function.
Rui
Perhaps you have specified ; as list separator in the Region control panel in Windows, or else in Excel in File > Options > Advanced > Editing Options
.jpg){kind=link}