I found this nice calculated column, Days since list item was created
On the demo tenant it works awesome. So i tried it at the production version. Here is the default language Dutch but everything is now English.
When i use this code:
=DATEVALUE(TEXT(NOW(),"mm/dd/yyyy")) - DATEVALUE(TEXT([Created],"mm/dd/yyyy"))
The output is: #Value! When i check the column, all the words are in Dutch. When i changed it back to English, i automatically changed to Dutch.
Is there a solution for this? I tried to write the code in Dutch but that doesn't work either.