Houstonking
New Member
- Joined
- Jul 12, 2016
- Messages
- 41
Hello,
I am confused as hell how to figure out when the agent had first sale and since first sale what did he sell in next 15 days. then again in next 15 days. I have the data by each day of the year. There are over 100 sales people. what i need to fig out what formula to put so that it takes the sales person hired in feb 3 or march 4 or april 25 having a sales on his first day then what he did in next 15 days and sum it up. each agent started on separate days and i want the 15 days to start from their first sale data. Any ideas?? please help. Thanks
I am confused as hell how to figure out when the agent had first sale and since first sale what did he sell in next 15 days. then again in next 15 days. I have the data by each day of the year. There are over 100 sales people. what i need to fig out what formula to put so that it takes the sales person hired in feb 3 or march 4 or april 25 having a sales on his first day then what he did in next 15 days and sum it up. each agent started on separate days and i want the 15 days to start from their first sale data. Any ideas?? please help. Thanks