Forum Discussion
Analysis formula based on dates - suggestions
Hi all! I am stumped! I have a large spreadsheet of sales figures by month for a number of years. I want to add in a formula that will calculate sales commissions. The Commissions are payable as f...
marionob I'm not 100% clear on your explanation, but I think that the attached would cover it; if not then please explain a bit more what you need exactly.
- Hi Savia, thanks for the prompt reply. So sorry I forgot to say, it needs to be dynamic based on the number of months because i want to be able to drag it forward into future months and we have hundreds to lines to be analysed. so what i was trying to do is write a formula to say count back 12 months from this month (cell AA2) and multiply each 10% and then count back another 12 months from Cell AA2 and multiply each by 1% and add the 2 totals. Do you think thats possible ?
also I couldnt open your attachment - so maybe youve done this for me lol!
Thanks!
