i would like to have an excel worksheet that tells me the pro-rated price of
several different products so when I punch in a date and select a product
(say something at $15/month or something at $20) it tells me what the
customer will have to pay for the remainder of the year. Typically, my cutoff
is the 15th of the month. So, if the customer buys something on the 10th, I
count the current month in the pro-rated price, and if they buy on the 20th,
I move it to the next month.