Restricting results using date formulas

[Guest]

Hello,

We are creating a spreadsheet for our sales team to calculate commissions on their sales. We have a condition where for 90 days from the entry of the first sale to a customer, they receive a higher commission then for sales made to that customer over 90 days. The formula uses the Date formula to calculate the number of days since the first entry of the sale and as long as it is less than 90 days, they get the higher commission. The problem is that as time goes on, the Date function will push these values past the 90 days and we will not have a historical representation of how the sales person is doing. Any suggestsions as to how we keep the commission percentages from changing as the date changes?

 

[Bob Umlas]

Once the calculation is done, you can freeze the values via copy/paste
special values...?

Hello,

We are creating a spreadsheet for our sales team to calculate commissions

on their sales. We have a condition where for 90 days from the entry of the
first sale to a customer, they receive a higher commission then for sales
made to that customer over 90 days. The formula uses the Date formula to
calculate the number of days since the first entry of the sale and as long
as it is less than 90 days, they get the higher commission. The problem is
that as time goes on, the Date function will push these values past the 90
days and we will not have a historical representation of how the sales
person is doing. Any suggestsions as to how we keep the commission
percentages from changing as the date changes?