I have a SharePoint List and I'd like to have a column to calculate the days it take to solve a ticket (Solution date - Submission Date).

I tried to create a calculated column, by using a formula = DATEDIF([Submission Date],[Solution Date],"D"), and return data with "Number". It didn't allow me to create this as it says Syntax error.

I researched and tried to replaced "," with ";" = DATEDIF([Submission Date];[Solution Date];"D") , still didn't work.

Both Solution date & Submission Date columns are formatted as "Date and Time" Type.


Try using this:

=DATEDIF([Solution Date], [Submission Date], "d")

Calculate the difference between two dates

  • Hello, still doesn't work - "The formula contains a syntax error or is not supported.".
    – Kiki
    Jul 6 '20 at 17:54
  • Try creating a new list in your SharePoint site, add two date columns and use this formula. just to make sure if there is any issue with the current SP list. Jul 6 '20 at 18:03
  • I tried to do it in another sharepoint and it worked. Now i wonder if the setting of this particular sharepoint has disabled the "Calculated Column" Function.. anyone knows where to check?
    – Kiki
    Jul 6 '20 at 18:49
  • I think there is no such setting to disable creating calculated column in list. Have you tried it in another SharePoint site or another SharePoint list? Jul 7 '20 at 5:44
  • @Kiki I don’t think it is possible to disable calculated column function in SharePoint. Can you use another formula in this list like “=INT([Submission Date]-[Solution Date])”? Jul 7 '20 at 6:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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