Freeze days remaining when 100%

Help please, I want to freeze days remaining when task 100% complete. Due date is O5, % complete is P5, Days +- is Q5. I wanted to display remaining days and freeze the days +- when P5 is 100%. P5 options are drop down 1% - 25% - 50% - 75% and 100%. I had a problem with days remaining displaying numbers when due date was empty but the below code worked so it now display nothing in days when nothing is entered in due date. In a nutshell when 100% line P5 freeze days in line Q5.

=IF(O9="","",IF(O9="Completed"," - ",O9-TODAY()))

Many thanks!

Try something like this.

=IF(P5<100%,O5-D5,IF(P5=100%,"Complete",""))

Where O5 - D5 is due Date less TODAY().

Capture item.PNG

It worked but shows "complete", how do I freeze the value to show how many days late or in some rare occasions early.

Many thanks, I'm terrible at Excel but I do support Programme Management forums.

Thanks

The problem is you cannot stop a Formula and change the result into a static Value without VBA Code.