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.