Forum Discussion
Solved
How to calculate the duration between two date columns in a List?
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 Sharepo...
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.
Thanks,
Vik
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.
Thanks,
Vik
I have a similar situation. I have a column that captures a person's started working date (let us say 1st June 2020). I want to create a column to automatically calculate the total experience real time. I added a column with today formula but I want to avoid this and use a formula instead to calculate the total experience with reference to started working date column. Also, would like to see if there is a possibility to get the result in decimals. Your formula was giving the response in intergers.