Hi all,
Here's what I want to do:
I want to know how to base a formula upon a specific recurring month, and another formula on all other months. One formula for every June, or every January. A second formula for every other month.
For example, I want to recognize 50% of yearly revenue in January, but (50%/11) of yearly revenue in all other months. But I want this to repeat depending on how long the contract is. So EACH january it would use formula 1, and every other month, formula 2.
Thanks so much!!
- Jeff