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.
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.
Awesome thank you