Forum Discussion
Date Range
Hi I have data of every sales guy in the team of their daily sales across the year with dates... I need to dynamically extract start data and number of days every sales guy is taking to earn $2000 ...
Hi.
Now 120 days process is working perfectly fine and thanks for supporting with quite effortless process. 120 - 160 days mean; we have min 120 days to achieve target and max 160 days. After 160 days, the sales guy didn't qualify for the sales incentive. Is this possible to have min and max days formula to count for $2000?
Now 120 days process is working perfectly fine and thanks for supporting with quite effortless process. 120 - 160 days mean; we have min 120 days to achieve target and max 160 days. After 160 days, the sales guy didn't qualify for the sales incentive. Is this possible to have min and max days formula to count for $2000?
I come back to my first formula, which already did exactly what you want. Minimum and maximum do not work at all. You can only count how many days it takes to reach the 2000$. That is the result of minimum and maximum.
I have made an example again. There it should possibly become clearer.
