Forum Discussion
Solved
Calculate days remaining in a task based on start date and percentage done.
Hi, I've searched for a solution for this but I'm struggling, possibly in part due to brain fog! I'm part of a big migration project, and I have a formula that works out how far along the project is...
Let's say the start date (6th Feb 2023) is in D100.
The end date is returned by
=D100+100%/C100*(TODAY()-D100)
Format the cell with the formula as a date.
When you asked what other info can we use, I can give you your second option, the number of issues resolved up to today
So we have the start date in C103, the number of issues resolved in C106 and the number of outstanding issues in C107. Sorry for any confusion. Happy to be told it's not doable.
So we have the start date in C103, the number of issues resolved in C106 and the number of outstanding issues in C107. Sorry for any confusion. Happy to be told it's not doable.
Oh and we're looking for an estimated completion date based on this info as before.
