Calculate difference of days

Question

I have two columns in a SP list. One is called 'Date Started' and the other one is called 'Date Ended'. I would like to calculate the difference in days. The problem I am facing is that the 'Date Ended' column has a timestamp whilst the other column does not. I only want to know the amount of days passed and dont need anything with the timestamp really.

navas16 · Answer

Hi&nbsp;alan32563&nbsp;,&nbsp;You can create calculated column and use the below formula.=DATEDIF(DateStarted,DateEnded,"D")Hope it helps.&nbsp;

alan32563 · Answer

navas16&nbsp;&nbsp;Hi thanks for this - I have tried this and it hasnt worked. It gives me an error in the syntax.&nbsp;Here is an example from my data (also I am from the UK so the date format is different)&nbsp;Date Started: 09/12/2023 12:45&nbsp;Date Ended: 12/12/2023&nbsp;Total days taken : 3&nbsp;