Calculating Percentage between dates with starting and ending percent

Hello,

I have a excel sheet where I calculate percentage between dates.
For now it starts with 100% and ends with 0%
But I would like to start with 80% and end with 5%

I am sure that the challenge is not too heavy.
(Excel workbook is in attachment)

Thanks, Davor

This will change the opening value to 80%:

=(($F$3-A2))/(($F$3-$F$2))*80/100

Are you saying that you want to and on 28/02/2017 with 5%?

Yes,

I want to end on 28/02/2017 with 5%

OK. Then try this:

=((($F$3-A2))/(($F$3-$F$2))*75/100)+0.05

This is it!
Thank you AliGW

You're welcome!