I can calculate the days between two dates by doing =[Due Date]-[Start Date] and that works. But I want to calculate how many months are between the two dates. I found this formula =DATEDIF([Start Date], [Due Date],"ym") but it does not work, Sharepoint just says: Syntax error.

Can anyone please assist?

Thank you!

Please note I am a beginner.

1 Answer 1


Depending on the language the SharePoint is configured in, it is possible that you need to use ; instead of ,. So try to use =DATEDIF([Start Date]; [Due Date]; "ym")

Hint: Most formlars can be tested in excel beforehand...

  • Thank you, much appreciated, this worked.
    – Brynja
    May 31, 2019 at 13:23

Your Answer

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

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