waseem abbas
New Member
- Joined
- Dec 5, 2022
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
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).
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).