Active Member
October 19, 2020
What is the best formula to use so I can calculate task completed against not completed given today’s date?
e.g. If a task is forecasted to take 10 days but after 7 days have elapsed task is only 3 days complete – I would like to use some conditional formatting highlighting a such based on a formula.
Task
10 days = 100%
7 Days Elapsed - Forecast should be 70% complete (Linear extrapolation example)
However
Task - 3 Days Complete - Actual will be 30% Complete
The difference is -40%
Thanks
Tony
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Active Member
October 19, 2020
Hi Catalin - many thanks for helping that's really kind.
I have uploaded the file attached.
Could you look at the data tab columns I, J, K?
Thanks
Tony
Any questions my email is lawlortony@hotmail.com
1 Guest(s)