I have attached a part of the excel sheet to help in understanding the problem.
I need a formula/formulas to help figure out the percentage on time based on the current date. I have a current Gate L-3 and the next Gate Date. I need the formula to look at the current gate and see if a date is filled into all the boxes before that gate. Example, if the current gate is 3, then there needs to be a date filled into Gate L, 1, & 2. If it is up to date on that information, then it is 100%. If a date is missing, example current gate is 3 but there are only dates filled into Gate L & 1, then the formula needs to figure out the percentage that is up to date. So three gates need to be filled in for 100%, but only 2 of the 3 are filled in so that percentage would be 66.7%. Then I need to take on the percentages from each row and have a total project percentage.
I hope the excel sheet attached helps understand the issue. And questions please let em know. This problem is a bit advanced for me to fully figure out.Test.xlsx
Bookmarks