Joseph, don't know is this matte for you. Since you are using TODAY() formula in column C, this will keep count the duration, even if remarks changed to 'Received'.

If received date always be > ATA date, then you can use IF formula to check, if D=date then D-C else TODAY()-B.
If received date <>ATA then I think will require Change_Event VBA.