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
Hi Tony,
Can you upload a sample file with your data structure?
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 [email protected]
Attachment included
Hi Tony,
Please check the file attached, see if that solves your problem. Looks more like a math problem, not excel.
