Get the immediate values from the adjacent columns based on the value of another column

I am trying to get the immediate next adjacent column values based on the values of another column. I tried by adding serial numbers and VLOOKUP() but I'm getting some mismatches.

The data is in columns A to C and the output required should be in column D.

Based on the column C, if the value is NA, I need the date from the next row for the same ID. If the next ID is different, I need the same date in column D.

Thanks