Quarter 2 (April- June) I need the formula that does the following:
Take the week of 5-Apr + 12-Apr +Apr-19 and that would populate for the [actual number], the remaining weeks would be [planned]. Than dynamically the formula would auto populate each week consecutively so that it would add the current week to the sum of the actual number and so on until we reached the remaining weeks at the end of the quarter in this case 28-Jun. At the end of the quarter there would be NO more [planned] since all weeks had been consumed and it would result in [actual number].
Any help with this would be apricated.