I'm building a project tracking tool and am trying to calculate the percent progress using dates. I essentially want to determine what percentage today is between the start date and end date, if that makes sense.
You can see in the image that the first column has the start date, the second has the end, and the final column is supposed to track progress, but all the rows that have a start date in the future have percentages well over 100%. Is there any way to set it to 0% and have it automatically begin tracking when it reaches the relevant date? Also, for some reason the formula (provided below) calculates percentage remaining rather than percentage elapsed, and i can't figure out how to reverse that.
An example of the formula being used in column J11 (pictured) is =(H11-TODAY())/(H11-G11) which is giving me 240%. This formula works for elapsed start dates, but can't find one that fits for future ones.
Apologies if this has been addressed elsewhere, but I couldn't find it if it was. Thank you in advance for any help!