I've been trying to have a formula that will calculate how much ideally the project should have spent based on the start and end dates... I have a budget, actuals, variance and unspent %. I just need a % goal of where we should be at (spent so far) based the aforementioned dates. Please see attached. The Start date (K78) will be in that cell it's now, the M9 (K80) is the end date. The formula will be in cell Q80... thx
Bookmarks