Calculate difference of days

[alan32563]

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.

[#2]

Hi @alan32563 ,

You can create calculated column and use the below formula.

=DATEDIF(DateStarted,DateEnded,"D")

Hope it helps.

[#3]

@navas16 

Hi thanks for this - I have tried this and it hasnt worked. It gives me an error in the syntax.

Here is an example from my data (also I am from the UK so the date format is different)

Date Started: 09/12/2023 12:45 

Date Ended: 12/12/2023

Total days taken : 3 

[#4]

@alan32563 I believe this formula works even with different time format. If possible, can you please share a screenshot of formula and error?