Forum Discussion
Calculate difference in time between dates in same column
Hi all, I have the following column, and I wish to calculate the difference between each row - ie the length of time between Row 2 (20/08/18) and Row 1 (18/01/2017). Any ideas on ...
My apologies, the dates should have been in ascending order as in the screenshot below now. There are other rows that I'd rather not show if possible for privacy reasons (ie work related), but the dates should be the column by which the table is sorted.
And to answer your other question, a calculated column would be the ideal scenario.
Thank you for your help so far!