Easy Excel formula
Budget: $10 – $30 USD
I need an excel sheet where I can type in twenty names in 20 rows.
In the first column is the sales person name.
in the third column is their sales goal for the month. For example, $31,000.
In the second column is an automatically updating daily goal based on how they did the day before.
For example, if they sell $1,250 on the first day of a 31 day month, their daily goal to sell for the 2nd of the month will be: $31,000 - $1250 = $29750, $29750/30(days left in the month) = $991(amount needed to be sold every day to hit their goal).
Then as their sales come in each day, there's a spot to enter their new sales number for the previous day to update the new daily sales goal number.
In the first column is the sales person name.
in the third column is their sales goal for the month. For example, $31,000.
In the second column is an automatically updating daily goal based on how they did the day before.
For example, if they sell $1,250 on the first day of a 31 day month, their daily goal to sell for the 2nd of the month will be: $31,000 - $1250 = $29750, $29750/30(days left in the month) = $991(amount needed to be sold every day to hit their goal).
Then as their sales come in each day, there's a spot to enter their new sales number for the previous day to update the new daily sales goal number.