I have a monthly goal of $4000, I track my reps daily on a 31 day base. I need the daily goal to change based on amount sold daily. I need it on a 31 day base with $0 being put in on days not worked. Daily goals will change to help reps know how much needs to be sold a day to meet $4000 by end of month. Please assist. $4000 / days worked (22) = starting daily goal. what would be formula for amount toward $4000 changing daily.
Last edited by TOAD21; 04-13-2016 at 01:11 PM.
Duplicate post - http://www.excelforum.com/excel-form...et-needed.html
Please don't duplicate posts. Just change the title of your previous post so that we can provide solutions.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks