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.
50 freelanceria on tarjonnut keskimäärin $22 tähän työhön
Hello, I can assist you to write an Excel formula that calculates daily goal based on how they did the day before. I'm ready to start. Please drop a PM if you’re interested. Best regards, Hoang
Hello, I can create excel formula I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.
Hey there, I am an Excel and VBA expert and have been working on it for more than 5 years. looking forward to getting a message from you, that's why we can proceed further. Thanks
Hi, I am an Excel Expert. I understand how to work with Excel formulas as well as other Excel operations. Chat me up so we can discuss further. Best regards, Emeka