Forum Discussion

Copper Contributor

Sep 12, 2023

Calculate difference of days

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 End...

Lists

SharePoint Online

navas16

Copper Contributor

Sep 12, 2023

Hi alan32563 ,

You can create calculated column and use the below formula.

=DATEDIF(DateStarted,DateEnded,"D")

Hope it helps.

Tongai

Copper Contributor

Jan 13, 2026

Thanks for this, worked for me using the following syntax:

=DATEDIF([Start Date],TODAY(),"D").