Formula that copies value at date

Hi,

I'm trying to make a progress sheet so others could see if I'm following the planned progress.
The picture shows what I've made, and what I want to do is to automatically copy the value in the red circle to the green range at the set date.

I've tried making IF(TODAY()=DATE;VALUE;"0"), but the thing is that it then returns "0" when it's not that particular date, while I want it to keep the value when the date has passed.
So I wondered if it's possible to copy the value and remove the formula, so when the date is correct the value will overwrite the formula!?

Also open for other suggestions!

asd.jpg

Thanks!!