nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,256
- Office Version
- 2016
Hi, I need to calculate a current progress review based on dates and the current time.
I have 5 columns (C,D,E, G and H).
C = Progress, a value between 0 and 100.
D = A target value (see below)
E = Variance (Difference between the target and the current).
G = Start Date
H = Due Date
C12 - I also have a cell that contains todays date - =now().
D - The target value. I need to calculate this in the following way.
I need to look at the values I have and work out the target progress, where we should be in terms of 0-100 as at today's date. Taking into account the time allocated H - G.
So, as an example, if we had a task that should last 100 days, today's date is 50 days from the start date, therefore our Target value would be 50. We should have completed 50% of the task on this day. However, if we record a progress of 40 then our Variance (E) will = -10
Hope this makes some kind of sense....
Thank you
I have 5 columns (C,D,E, G and H).
C = Progress, a value between 0 and 100.
D = A target value (see below)
E = Variance (Difference between the target and the current).
G = Start Date
H = Due Date
C12 - I also have a cell that contains todays date - =now().
D - The target value. I need to calculate this in the following way.
I need to look at the values I have and work out the target progress, where we should be in terms of 0-100 as at today's date. Taking into account the time allocated H - G.
So, as an example, if we had a task that should last 100 days, today's date is 50 days from the start date, therefore our Target value would be 50. We should have completed 50% of the task on this day. However, if we record a progress of 40 then our Variance (E) will = -10
Hope this makes some kind of sense....
Thank you
