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.