Please help me determine my formula

New Contributor

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!

2 Replies
best response confirmed by Tammy_H146 (New Contributor)


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!!