DATEDIFF between two rows in different columns

Hi all, I have a table in which there are two calculated columns ‘Status10Date’ and ‘DateCompletedCC’ I need the DateDiff between the two dates, however these are not on the same rows because of st...