1

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.

Improve this question

2 Answers 2

Reset to default
0

Try using this:

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

Calculate the difference between two dates

Improve this answer
8
  • Hello, still doesn't work - "The formula contains a syntax error or is not supported.".
    – Kiki
    Jul 6, 2020 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.
    – Ganesh Sanap - MVP
    Jul 6, 2020 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, 2020 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?
    – Ganesh Sanap - MVP
    Jul 7, 2020 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])”?
    – Chelsea_MSFT
    Jul 7, 2020 at 6:03
0

Try using this:

=DATA.DIFF([Travel start date];[Travel end date];"D")
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.