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

Hey everyone,



I have been stuck for a while trying to figure this out.



This is what i have:

Start Date End Date Days Weight Status Planned Value Actual Value

1-Feb-2018 5-Feb-2018 5 10% Red/Green/Yellow ( Function 1 )



Function 1 = =IF(AND(Today()>=Start Date,Today()<=End Date),Days/Weight,"Not Tracked")



This function reads if the project date has started using Today's date,



If it has started then it will give me how much i should progress per day.



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.



I want it in 1-Feb-2018 to give me 2%

in 2-Feb-2018 to give me 4%

in 3-Feb-2018 to give me 6%

so on till 5-Feb-2018 to give me 10%



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 ?

Originally Posted by FlameRetired

Hi AbdulkareemAlhassni. Welcome to the forum.

The first thought that comes to mind is something like this.

Formula:

=IF((TODAY()>=Start Date)*(TODAY()<=End Date),SUMPRODUCT(--(TODAY()>=Start Date),--(TODAY()<=End Date),Days/Weight),"Not Tracked")

Without an uploaded sample workbook I can not say for sure. The description is a bit vague (definitions of named ranges, etc.)
You almost always benefit by uploading a workbook.

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

Thanks alot friend, i managed to do it