SOLVED

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)
Solution

@Bernd Kroon You can use the following approach 

Vikram_Samal_0-1590610121059.png

This will be the way column will be defined:

Vikram_Samal_1-1590610219403.png

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

 

Thanks,

Vik