Return A cumulative Percentage value based on Today's date referencing a start and end dat

[AbdulkareemAlhassni]

[FONT=&quot]Hey everyone,[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I have been stuck for a while trying to figure this out.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]This is what i have:[/FONT]
[FONT=&quot]Start Date End Date Days Weight Status Planned Value Actual Value[/FONT]
[FONT=&quot]1-Feb-2018 5-Feb-2018 5 10% Red/Green/Yellow ( Function 1 )[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Function 1 = =IF(AND(Today()>=Start Date,Today()<=End Date),Days/Weight,"Not Tracked")[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]This function reads if the project date has started using Today's date,[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]If it has started then it will give me how much i should progress per day.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I want the progress to add up everyday to the last.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]for example: now its giving me 3% per day which is 30% in 30 days.[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I want it in 1-Feb-2018 to give me 2%[/FONT]
[FONT=&quot]in 2-Feb-2018 to give me 4%[/FONT]
[FONT=&quot]in 3-Feb-2018 to give me 6%[/FONT]
[FONT=&quot]so on till 5-Feb-2018 to give me 10%[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]in the planned cell. I want it to read the date from the range of the start and end date how can i do that ?[/FONT]

 

[AbdulkareemAlhassni]

I want the progress to add up everyday to the last end date.


for example: now its giving me 2% per day which is 10% in 5 days.

Small Correction

 

[AbdulkareemAlhassni]

I want the progress to add up everyday to the last end date.


for example: now its giving me 2% per day which is 10% in 5 days.

Small Correction

[FONT=&quot]https://sheet.zoho.com/sheet/editor.do?doc=398d93a2eb56bc8b16385058108a48ef10c59b3ea0a8357ef8a786d54d8a4eac72d14a21df8ee88b771ad8420a383bda6e43b4c26d74fceb68cd5f2c8adaa988

[/FONT]This is the excel file in cell K12 i am having the issue


****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[FONT=&quot]https://sheet.zoho.com/sheet/editor.do?doc=398d93a2eb56bc8b16385058108a48ef10c59b3ea0a8357ef8a786d54d8a4eac72d14a21df8ee88b771ad8420a383bda6e43b4c26d74fceb68cd5f2c8adaa988[/FONT]</body>