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 status changes on the order number.

I tried the formula below, but it results in error.

This is a sample to better understand the situation: