Forum Discussion
Kirk-Anderson
Apr 10, 2023Copper Contributor
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...
- Apr 10, 2023
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.
HansVogelaar
Apr 10, 2023MVP
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.
- Kirk-AndersonApr 10, 2023Copper ContributorAwesome thank you
- Kirk-AndersonApr 12, 2023Copper ContributorFollow up question, our project (migration of data between 2 health systems with a 3 month gap) is generating a lot of issues, which the spreadsheet keeps a track of, these will be dealt with one the main project gets to 100%. This figure is a number, not a percentage, is there a similar formula you could come up with that would estimate completion date if the start date is in C103 and the number of issues is in C101? Thanks in advance.
- HansVogelaarApr 12, 2023MVP
You have the start date in C103 and the number of issues in C101. What other info can we use? The number of issues resolved per day? The number of issues has been resolved up to today? Something else?
- Kirk-AndersonApr 12, 2023Copper ContributorI could calculate the number of completed migration tasks as opposed to ones that generated issues, as it's either or from a pick list. Would that do it?