Forum Discussion
Solved
Please help me determine my formula
I am trying to determine the formula that will calculate where we are at in meeting a goal for the year as of todays date. So, for example, I want to achieve 30 units (cell A2) this year and I have sold 10 units (cell B2) as of today (todays date is in cell A1 as "=TODAY()"). What does the formula look like to display that result? Thank you for your help!
You are at =B2/A2 of the goal, that is ~ 33.3%
If progression was linear, you'd be at =(A1-DATE(YEAR(A1),1,0))/(DATE(YEAR(A1),12,31)-DATE(YEAR(A1),1,0)) of the goal, that is ~ 53.7%.
Depending on how you want to measure it, you are 53.7%-33.3% =20.4% behind, or you are at 33.3%/53.7% = 62% of where you should have been.
You are at =B2/A2 of the goal, that is ~ 33.3%
If progression was linear, you'd be at =(A1-DATE(YEAR(A1),1,0))/(DATE(YEAR(A1),12,31)-DATE(YEAR(A1),1,0)) of the goal, that is ~ 53.7%.
Depending on how you want to measure it, you are 53.7%-33.3% =20.4% behind, or you are at 33.3%/53.7% = 62% of where you should have been.
- Perfect! Thank you for your help!!
