Using date commands in calculated fields

Question

I am following this article: Examples of common formulas in lists

A simple sample is this:

=DATEDIF([Dato1],[Dato2],"d")

However when I save the column I get following error:

Sorry, something went wrong The formula contains a syntax error or is not supported.

If I just do this it works:

=[Dato1]-[Dato2]

However I need to calculate hours and days between two dates so I need some of the commands.

Any pointer what I am doing wrong?

Answer 1

Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

Try using this:

=DATEDIF([Dato1];[Dato2];"d")