How to calculate the duration between two date columns in a List?

Occasional Contributor

Calculation and display of duration of a proces, calculated as difference of two column in SP list

I want to store the difference in days in column C between two columns A and B of a List in Sharepoint.  Both A and B are Date column. Column C is a calculated column. I work in NL, using Netherlands as locale. Field A and B correctly display date/Time in format of Netherlands. The formula in column C (which is A-B) yield a result, the delta in hours is correct, but it shows a date in the 18th century. How can I create the correct number of days?

2 Replies
best response confirmed by Bernd Kroon (Occasional Contributor)

@Bernd Kroon You can use the following approach 


This will be the way column will be defined:


I hope this gives you some directions to think. Mark the response appropriately if it help you finding the solution.