0

I am trying create a simple calculated column, but I am getting an error:

The formula contains a syntax error or is not supported

The formula looks like:

=DATE(YEAR([RevisjonsDato])+1,MONTH([RevisjonsDato]),DAY([RevisjonsDato]))

Can any one see what I am doing wrong in the formula?

Improve this question
2
  • In some countries you need to replace ',' with ';'. Otherwise I don't see any issue for now. Will check it.
    – HappySPUser
    Sep 27, 2017 at 10:44
  • Pretty sure @HappySPUser is correct about using ; instead of , for the Nordic languages
    – Robert Lindgren
    Sep 27, 2017 at 10:49

3 Answers 3

Reset to default
2

I've tested it with your formula and it worked well Result of calculated column testing

I suggest to try to change the commas with semicolons.

For testing any calculation you can use Excel as the possible commands are nearly equal. (in SharePoint there are a bit less possibilities)

Improve this answer
2
  • Changing the commas with semicolons helped me. Greetings from the Netherlands.
    – cavit
    Feb 26, 2019 at 18:52
  • I am glad I was able to help. :-)
    – HappySPUser
    Mar 5, 2019 at 7:24
0

Also when working with calculated columns I find it rather usefull to 'design' the formula in excel first. That way youy get better error handling compared to SharePoint.

Improve this answer
0

the Formula is correct. i think the probleme come from the Column "RevisjonsDato". the column "RevisjonsDato" must be a date Column.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.